Archive

Number.From

Syntax Number.From(value as any, optional culture as nullable text) as nullable number Description Returns a number value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, Number.From returns null. If the given value is… Read More »Number.From

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 / RoundingMode.ToEven

Number.E

Syntax null Description A constant that represents 2.7182818284590451, the value for e up to 16 decimal digits. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.E

Number.IsOdd

Syntax Number.IsOdd(number as number) as logical Description Indicates if the value is odd. Returns true if number is an odd number, false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.IsOdd

Number.BitwiseXor

Syntax Number.BitwiseXor(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the result of performing a bitwise “XOR” (Exclusive-OR) between number1 and number2. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.BitwiseXor

Number.Sqrt

Syntax Number.Sqrt(number as nullable number) as nullable number Description Returns the square root of number. If number is null, Number.Sqrt returns null. If it is a negative value, Number.NaN is returned (Not a number). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions /… Read More »Number.Sqrt

Number.FromText

Syntax Number.FromText(text as nullable text, optional culture as nullable text) as nullable number Description Returns a number value from the given text value, text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.FromText

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 Power Query M Functions / Number Functions / Number.NegativeInfinity

Number.Mod

Syntax Number.Mod(number as nullable number, divisor as nullable number, optional precision as nullable number) as nullable number Description Returns the remainder resulting from the integer division of number by divisor. If number or divisor are null, Number.Mod returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Number.Mod

Byte.From

Syntax Byte.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as nullable number Description Returns a 8-bit integer number> value from the given value. If the given value> is null, Byte.From returns null. If the given value is number within the… Read More »Byte.From