Archive

Number.Random

Syntax Number.Random() as number Description Returns a random number between 0 and 1. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Random

Number.RoundTowardZero

Syntax Number.RoundTowardZero(number as nullable number, optional digits as nullable number) as nullable number Description Returns the result of rounding number based on the sign of the number. This function will round positive numbers down and negative numbers up. If digits is specified, number is rounded… Read More »Number.RoundTowardZero

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

Percentage.From

Syntax Percentage.From(value as any, optional culture as nullable text) as nullable number Description Returns a percentage value from the given value. If the given value is null, Percentage.From returns null. If the given value is text with a trailing percent symbol, then the converted decimal… Read More »Percentage.From

Number.Sinh

Syntax Number.Sinh(number as nullable number) as nullable number Description Returns the hyperbolic sine of number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Sinh

Number.Cos

Syntax Number.Cos(number as nullable number) as nullable number Description Returns the cosine of number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Cos

Single.From

Syntax Single.From(value as any, optional culture as nullable text) as nullable number Description Returns a Single number value from the given value. If the given value is null, Single.From returns null. If the given value is number within the range of Single, value is returned,… Read More »Single.From

Int16.From

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

Number.Epsilon

Syntax null Description A constant value that represents the smallest positive number a floating-point number can hold. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Epsilon

Number.RandomBetween

Syntax Number.RandomBetween(bottom as number, top as number) as number Description Returns a random number between bottom and top. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.RandomBetween