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 …