Power-Query公式

AboutNumberConstantsFunctionNumber.NaNNumber.NegativeInfinityNumber.PositiveInfinityNumber.EpsilonNumber.ENumber.PIInformationFunctionNumber.IsNaNNumber.IsEvenNumber.IsOddConversionandformattingFunctionNumber.FromTextNumber.ToTextNumber.FromByte.FromInt8.FromInt16.FromInt32.FromInt64.FromSingle.FromDouble.FromDecimal.FromCurrency.FromPercentage.FromRoundingFunctionNumber.RoundDownNumber.RoundUpNumber.RoundTowardZeroNumber.RoundAwayFromZeroNumber.RoundOperationsFunctionNumber.AbsNumber.SignNumber.IntegerDivideNumber.ModNumber.PowerNumber.SqrtNumber.ExpNumber.LnNumber.LogPowerQuery(informallyknownasM)formulacategoriesThistopicappliestothePowerQueryFormulaLanguagewhichcanbeusedwithPowerQueryandPowerBIDesktoptobuildqueriesthatmashupdata.Seethelistoffunctioncategories.ThefollowingtablesdescribethePowerQueryformulacategoriesthatcanbeusedtomanuallycreateormodifyqueries.TheseformulafunctionscanalsobeusedinthePowerBIDesigner,intheQueryview.Number.Log10Number.FactorialNumber.CombinationsNumber.PermutationsRandomFunctionNumber.RandomNumber.RandomBetweenTrigonometryFunctionNumber.AcosNumber.AsinNumber.AtanNumber.Atan2Number.CosNumber.CoshNumber.SinNumber.SinhNumber.TanNumber.TanhBytesFunctionNumber.BitwiseAndNumber.BitwiseNotNumber.BitwiseOrNumber.BitwiseShiftLeftNumber.BitwiseShiftRightNumber.BitwiseXorTextInformationFunctionText.LengthTextComparisonsFunctionCharacter.FromNumberCharacter.ToNumberText.FromText.FromBinaryText.NewGuidText.ToBinaryText.ToListValue.FromTextExtractionFunctionText.AtText.RangeText.StartFunctionText.EndModificationFunctionText.InsertText.RemoveText.RemoveRangeText.ReplaceText.ReplaceRangeMembershipFunctionText.ContainsText.EndsWithText.PositionOfText.PositionOfAnyText.StartsWithTransformationsFunctionText.CleanText.CombineText.LowerText.PadEndText.PadStartText.ProperText.RepeatText.SplitText.SplitAnyText.TrimText.TrimEndText.TrimStartText.UpperLogicalFunctionLogical.FromLogical.FromTextLogical.ToTextDateFunctionDate.AddDaysDate.AddMonthsDate.AddQuartersDate.AddWeeksDate.AddYearsDate.DayDate.DayOfWeekDate.DayOfYearDate.DaysInMonthDate.EndOfDayDate.EndOfMonthDate.EndOfQuarterDate.EndOfWeekDate.EndOfYearDate.FromDate.FromTextDate.IsInCurrentMonthDate.IsInCurrentQuarterDate.IsInCurrentWeekDate.IsInCurrentYearDate.IsInNextMonthDate.IsInNextQuarterDate.IsInNextWeekDate.IsInNextYearDate.IsInPreviousMonthDate.IsInPreviousQuarterDate.IsInPreviousWeekDate.IsInPreviousYearDate.IsInYearToDateDate.IsLeapYearDate.MonthDate.QuarterOfYearDate.StartOfDayDate.StartOfMonthDate.StartOfQuarterDate.StartOfWeekDate.StartOfYearDate.ToRecordDate.ToTextDate.WeekOfMonthDate.WeekOfYearDate.Year#dateTimeFunctionTime.EndOfHourTime.FromTime.FromTextTime.HourTime.MinuteTime.SecondTime.StartOfHourTime.ToRecordTime.ToTextDateTimeFunctionDateTime.AddZoneDateTime.DateDateTime.FixedLocalNowDateTime.FromDateTime.FromFileTimeDateTime.FromTextDateTime.LocalNowDateTime.TimeDateTime.ToRecordDateTime.ToTextDateTimeZoneFunctionDateTimeZone.FixedLocalNowDateTimeZone.FixedUtcNowDateTimeZone.FromDateTimeZone.FromFileTimeDateTimeZone.FromTextDateTimeZone.LocalNowDateTimeZone.RemoveZoneDateTimeZone.SwitchZoneDateTimeZone.ToLocalDateTimeZone.ToRecordDateTimeZone.ToTextDateTimeZone.ToUtcDateTimeZone.UtcNowDateTimeZone.ZoneHoursDateTimeZone.ZoneMinutesDurationFunctionDuration.DaysDuration.FromDuration.FromTextDuration.HoursDuration.MinutesDuration.SecondsDuration.ToRecordDuration.TotalDaysDuration.TotalHoursDuration.TotalMinutesDuration.TotalSecondsDuration.ToTextRecordInformationFunctionRecord.FieldCountRecord.HasFieldsTransformationsFunctionRecord.AddFieldRecord.CombineRecord.TransformFieldsRecord.RemoveFieldsRecord.ReorderFieldsRecord.RenameFieldsSelectionFunctionRecord.FieldRecord.FieldValuesRecord.FieldNamesRecord.FieldOrDefaultRecord.SelectFieldsSerializationFunctionRecord.ToTableRecord.FromTableRecord.ToTableParameterValuesThefollowingtypedefinitionsareusedtodescribetheparametervaluesthatarereferencedinRecordfunctionsabove.ListThesefunctionsdealwithlistofvalues.InformationFunctionList.CountList.NonNullCountList.IsEmptySelectionFunctionList.AlternateList.DistinctList.IsDistinctList.SelectList.FirstList.FirstNList.InsertRangeList.LastList.LastNList.MatchesAllList.MatchesAnyList.PositionsList.RangeList.SingleList.SingleOrDefaultList.SkipList.BufferList.FindTextTransformationfunctionsFunctionMissingFieldoptionTransformoperationsRenameoperationsList.AccumulateList.CombineList.TransformList.TransformManyList.RepeatList.ReplaceRangeList.RemoveRangeList.RemoveFirstNList.RemoveLastNList.ReverseList.RemoveMatchingItemsList.RemoveItemsList.RemoveNullsList.ReplaceMatchingItemsList.ReplaceValueFunctionList.ContainsList.ContainsAllList.ContainsAnyList.PositionOfList.PositionOfAnyList.AnyTrueList.AllTrueFunctionList.DifferenceList.IntersectList.UnionComparabledatatypesNumberSinceallvaluescanbetestedforequality,thesefunctionscanoperateoverheterogeneouslists.MembershipfunctionsSetoperationsOrderingfunctionsperformcomparisons.Allvaluesthatarecomparedmust