# 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 …