Syntax Number.IsNaN(number as number) as logical Description Indicates if the value is NaN (Not a number). Returns true if number is equivalent to Number.IsNaN, false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.IsNaN
Syntax Number.Sign(number as nullable number) as nullable number Description Returns 1 for if number is a positive number, -1 if it is a negative number, and 0 if it is zero. If number is null, Number.Sign returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »Number.Sign
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.PositiveInfinity
Syntax Number.RoundUp(number as nullable number, optional digits as nullable number) as nullable number Description Returns the result of rounding number down to the previous highest integer. If number is null, Number.RoundDown returns null. If digits is specified, number is rounded to the digits number of… Read More »Number.RoundUp
Syntax Number.BitwiseAnd(number1 as nullable number, number2 as nullable number) as nullable number Description Returns the result of performing a bitwise “And” operation 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.BitwiseAnd
Syntax Number.Asin(number as nullable number) as nullable number Description Returns the arcsine of number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Asin
Syntax Int32.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as nullable number Description Returns a 32-bit integer number value from the given value. If the given value is null, Int32.From returns null. If the given value is number within the… Read More »Int32.From
Syntax Number.Tanh(number as nullable number) as nullable number Description Returns the hyperbolic tangent of number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Tanh
Syntax Number.Exp(number as nullable number) as nullable number Description Returns the result of raising e to the power of number (exponential function). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Exp
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 Power Query M Functions / Number Functions / Number.NaN