Archive

Number.Ln

Syntax Number.Ln(number as nullable number) as nullable number Description Returns the natural logarithm of a number, number. If number is null Number.Ln returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Ln

Number.Power

Syntax Number.Power(number as nullable number, power as nullable number) as nullable number Description Returns the result of raising number to the power of power. If number or power are null, Number.Power returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Power

Number.Abs

Syntax Number.Abs(number as nullable number) as nullable number Description Returns the absolute value of number. If number is null, Number.Abs returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Abs

Number.Combinations

Syntax Number.Combinations(setSize as nullable number, combinationSize as nullable number) as nullable number Description Returns the number of unique combinations from a list of items, setSize with specified combination size, combinationSize. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Combinations

Number.Tan

Syntax Number.Tan(number as nullable number) as nullable number Description Returns the 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.Tan

Number.Permutations

Syntax Number.Permutations(setSize as nullable number, permutationSize as nullable number) as nullable number Description Returns the number of permutations that can be generated from a number of items, setSize, with a specified permutation size, permutationSize. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions /… Read More »Number.Permutations

Int64.From

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

Number.Sin

Syntax Number.Sin(number as nullable number) as nullable number Description Returns the 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.Sin

Number.Factorial

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

Number.ToText

Syntax Number.ToText(number as nullable number, optional format as nullable text, optional culture as nullable text) as nullable text Description Formats the numeric value number to a text value according to the format specified by format. The format is a single character code optionally followed by… Read More »Number.ToText