Number Functions
Number.Ln
Syntax Number.Ln(number as nullable number) as nullable number Description Returns the natural logarithm of a …
Number.Power
Syntax Number.Power(number as nullable number, power as nullable number) as nullable number Description Returns the …
Number.Abs
Syntax Number.Abs(number as nullable number) as nullable number Description Returns the absolute value of number. …
Number.Cos
Syntax Number.Cos(number as nullable number) as nullable number Description Returns the cosine of number. Reference …
Decimal.From
Syntax Decimal.From(value as any, optional culture as nullable text) as nullable number Description Returns a …
Number.PI
Syntax null Description A constant that represents 3.1415926535897932, the value for pi up to 16 …
Number.Log10
Syntax Number.Log10(number as nullable number) as nullable number Description Returns the base 10 logarithm of …
Number.RandomBetween
Syntax Number.RandomBetween(bottom as number, top as number) as number Description Returns a random number between …
Number.Epsilon
Syntax null Description A constant value that represents the smallest positive number a floating-point number …
Int16.From
Syntax Int16.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Single.From
Syntax Single.From(value as any, optional culture as nullable text) as nullable number Description Returns a …
Number.Sinh
Syntax Number.Sinh(number as nullable number) as nullable number Description Returns the hyperbolic sine of number. …
Percentage.From
Syntax Percentage.From(value as any, optional culture as nullable text) as nullable number Description Returns a …
Number.RoundTowardZero
Syntax Number.RoundTowardZero(number as nullable number, optional digits as nullable number) as nullable number Description Returns …
Number.Combinations
Syntax Number.Combinations(setSize as nullable number, combinationSize as nullable number) as nullable number Description Returns the …
Number.Tan
Syntax Number.Tan(number as nullable number) as nullable number Description Returns the tangent of number. Reference …
Number.Permutations
Syntax Number.Permutations(setSize as nullable number, permutationSize as nullable number) as nullable number Description Returns the …
Int64.From
Syntax Int64.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Number.Sin
Syntax Number.Sin(number as nullable number) as nullable number Description Returns the sine of number. Reference …
Number.Factorial
Syntax Number.Factorial(number as nullable number) as nullable number Description Returns the factorial of the number …
Number.ToText
Syntax Number.ToText(number as nullable number, optional format as nullable text, optional culture as nullable text) …
Number.Random
Syntax Number.Random() as number Description Returns a random number between 0 and 1. Reference Data …
RoundingMode.TowardZero
Syntax null Description RoundingMode.TowardZero Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / …
Number.BitwiseOr
Syntax Number.BitwiseOr(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the …
Number.Atan
Syntax Number.Atan(number as nullable number) as nullable number Description Returns the arctangent of number. Reference …
Number.IsEven
Syntax Number.IsEven(number as number) as logical Description Indicates if the value, number, is even by …
Number.Cosh
Syntax Number.Cosh(number as nullable number) as nullable number Description Returns the hyperbolic cosine of number. …
Number.Round
Syntax Number.Round(number as nullable number, optional digits as nullable number, optional roundingMode as nullable number) …
Number.RoundDown
Syntax Number.RoundDown(number as nullable number, optional digits as nullable number) as nullable number Description Returns …
Number.Acos
Syntax Number.Acos(number as nullable number) as nullable number Description Returns the arccosine of number. Reference …
RoundingMode.AwayFromZero
Syntax null Description RoundingMode.AwayFromZero Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / …
Number.IntegerDivide
Syntax Number.IntegerDivide(number1 as nullable number, number2 as nullable number, optional precision as nullable number) as …
Number.BitwiseShiftRight
Syntax Number.BitwiseShiftRight(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the …
Number.PositiveInfinity
Syntax null Description A constant value that represents 1 divided by 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference …
Number.Sign
Syntax Number.Sign(number as nullable number) as nullable number Description Returns 1 for if number is …
Number.IsNaN
Syntax Number.IsNaN(number as number) as logical Description Indicates if the value is NaN (Not a …
RoundingMode.Down
Syntax null Description RoundingMode.Down Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / …
Int8.From
Syntax Int8.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Number.BitwiseNot
Syntax Number.BitwiseNot(number as any) as any Description Returns the result of performing a bitwise “Not” …
Double.From
Syntax Double.From(value as any, optional culture as nullable text) as nullable number Description Returns a …
Number.BitwiseShiftLeft
Syntax Number.BitwiseShiftLeft(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the …
Number.Log
Syntax Number.Log(number as nullable number, optional base as nullable number) as nullable number Description Returns …
RoundingMode.Up
Syntax null Description RoundingMode.Up Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / …
Currency.From
Syntax Currency.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Number.RoundAwayFromZero
Syntax Number.RoundAwayFromZero(number as nullable number, optional digits as nullable number) as nullable number Description Returns …
Number.Atan2
Syntax Number.Atan2(y as nullable number, x as nullable number) as nullable number Description Returns the …
Byte.From
Syntax Byte.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Number.Mod
Syntax Number.Mod(number as nullable number, divisor as nullable number, optional precision as nullable number) as …
Number.NegativeInfinity
Syntax null Description A constant value that represents -1 divided by 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference …
Number.FromText
Syntax Number.FromText(text as nullable text, optional culture as nullable text) as nullable number Description Returns …
Number.Sqrt
Syntax Number.Sqrt(number as nullable number) as nullable number Description Returns the square root of number. …
Number.BitwiseXor
Syntax Number.BitwiseXor(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the …
Number.IsOdd
Syntax Number.IsOdd(number as number) as logical Description Indicates if the value is odd. Returns true …
Number.E
Syntax null Description A constant that represents 2.7182818284590451, the value for e up to 16 …
RoundingMode.ToEven
Syntax null Description RoundingMode.ToEven Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / …
Number.From
Syntax Number.From(value as any, optional culture as nullable text) as nullable number Description Returns a …
Number.NaN
Syntax null Description A constant value that represents 0 divided by 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference …
Number.Exp
Syntax Number.Exp(number as nullable number) as nullable number Description Returns the result of raising e …
Number.Tanh
Syntax Number.Tanh(number as nullable number) as nullable number Description Returns the hyperbolic tangent of number. …
Int32.From
Syntax Int32.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as …
Number.Asin
Syntax Number.Asin(number as nullable number) as nullable number Description Returns the arcsine of number. Reference …
Number.BitwiseAnd
Syntax Number.BitwiseAnd(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the …
Number.RoundUp
Syntax Number.RoundUp(number as nullable number, optional digits as nullable number) as nullable number Description Returns …