Number functions

Number functions functions for Power Query M language.

Functions

FunctionDescription
Byte.FromThe function Byte.From returns an 8-bit integer number value based on the input value provided. If the input value is null, then Byte.From will also return null. If the input value is a number within ...
Currency.FromThis function retrieves a currency value based on the input provided. If the input is null, the function will also return null. If the input is a number within the acceptable currency range, the funct...
Decimal.FromThis function retrieves a Decimal number value based on the input provided. If the input is null, the function will return null. If the input is a number within the appropriate range for Decimal, the ...
Double.FromThe function Double.From returns a numerical value of type Double based on the input provided. If the input is null, the function will return null. If the input is a number within the acceptable range...
Int16.FromThe function Int16.From returns a 16-bit integer number value based on the input value provided. If the input value is null, the function returns null. If the input value is a number within the range ...
Int32.FromThe function Int32.From returns a 32-bit integer number value from the input value. When the input value is null, Int32.From also returns null. If the input value is a number within the range of a 32-...
Int64.FromThe function Int64.From returns a 64-bit integer number value based on the input value provided. If the input value is null, then Int64.From will also return null. If the input value is a number withi...
Int8.FromThe function Int8.From returns a signed 8-bit integer number value based on the input given. If the input is null, the function returns null as well. If the input is a number within the range of a sig...
Number.AbsThis function is used to calculate the absolute value of a given number. If the input number is null, the function will also return null. The parameter "number" refers to the value for which the absol...
Number.AcosThe function retrieves the arccosine value of a given number.
Number.AsinThis function calculates and returns the inverse sine of a given numerical value.
Number.AtanThis function calculates and returns the arctangent of a given number.
Number.Atan2The function calculates the angle, measured in radians, whose tangent is the ratio of two numbers y and x.
Number.BitwiseAndThis function calculates the outcome of applying a bitwise "And" operation to number1 and number2.
Number.BitwiseNotThis function returns the outcome of applying a bitwise negation operation to a numerical value.
Number.BitwiseOrThis function computes the bitwise "Or" operation between number1 and number2, resulting in a new value.
Number.BitwiseShiftLeftReturns the output after shifting the binary representation of number1 to the left by the specified number of bits provided in number2.
Number.BitwiseShiftRightThis function will calculate the result of a bitwise shift to the right on number1, by the specified number of bits number2.
Number.BitwiseXorThis function calculates the bitwise XOR operation between two numbers, number1 and number2, and returns the result.
Number.CombinationsThis function calculates the total number of distinct combinations that can be generated from a given list of items. It takes two parameters: setSize, which represents the total number of items in the...
Number.CosThis function calculates and returns the cosine value of a given number.
Number.CoshThis function calculates and returns the hyperbolic cosine value of a given number.
Number.ExpThis function calculates the exponential value of a given number. The "number" parameter specifies the number for which the exponential value will be calculated. If the "number" parameter is empty, th...
Number.FactorialThis function will calculate and return the factorial of a given number.
Number.FromThis function retrieves a numerical value from the provided input. An optional culture parameter can be specified (e.g., "en-US"). If the input is null, the function returns null. If the input is alre...
Number.FromTextRetrieve a numerical value from the provided text string, text.text, which represents a numerical value in a standardized format like "15", "3,423.10", or "5.0E-10". The optional parameter, culture, c...
Number.IntegerDivideThe function Number.IntegerDivide calculates the quotient of two numbers (number1 and number2) and returns only the whole number part. If either number1 or number2 is not specified, the result will be...
Number.IsEvenThis function determines whether the input number is even or not. It returns true if the number is even, and false if it is not.
Number.IsOddThis function determines whether a given value is odd. It will return true if the number is odd, and false if it is not.
Number.IsnullThis function checks if a value is null (not a number). It returns "true" if the number is equal to Number.IsNull, and "false" otherwise.
Number.LnThis function calculates the natural logarithm of a given number. If the number is null, the function will also return null.
Number.LogThis function calculates the logarithm of a given number to a specific base. If the base is not provided, the default value used is Number.E. If the number is null, the function will return null.
Number.Log10This function calculates the base 10 logarithm of the input number. If the input number is null, the function will also return null.
Number.ModThe function Number.Mod calculates the remainder of dividing the integer number by the divisor. If either the number or the divisor is null, the function will return null. Parameters: - number: the d...
Number.PermutationsReturns the total number of possible arrangements that can be created from a given set of items, setSize, of a specific size for each arrangement, permutationSize.
Number.PowerReturns the outcome of multiplying number by itself power number of times. If either number or power is empty, the function Number.Power will output a null value. "number" refers to the base value, wh...
Number.RandomGenerates a random decimal number within the range of 0 to 1.
Number.RandomBetweenThis function generates a random number within a specified range of values, defined by the bottom and top parameters.
Number.RoundThis function returns the rounded result of a given number to the nearest whole number. If the number is null, the function will return null as well. By default, the number is rounded to the nearest i...
Number.RoundAwayFromZeroThis function returns the rounded result of a number based on its sign. Positive numbers are rounded up, while negative numbers are rounded down. If a specific number of decimal digits is specified, t...
Number.RoundDownThis function calculates the rounded down integer of a given number. If the number provided is null, the function will return null. If a specific number of decimal digits are specified, the function w...
Number.RoundTowardZeroThis function returns the rounded result of a number based on its sign. It rounds positive numbers downward and negative numbers upward. If a specific number of decimal digits is indicated, the number...
Number.RoundUpThis function calculates and returns the rounded value of a given number to the nearest whole number. If the input number is null, the function will return null. Additionally, if a specific number of ...
Number.SignThe function Number.Sign returns different values based on the input number: 1 indicates a positive number, -1 indicates a negative number, and 0 indicates zero. If the input number is null, the funct...
Number.SinThis function calculates and outputs the sine value of a given number.
Number.SinhThis function calculates the hyperbolic sine of a given number.
Number.SqrtThe function returns the square root of a given number. If the number is null, the function will also return null. And if the number is negative, the function will return NaN (Not a Number).
Number.TanReturns the value of the tangent function applied to a given numerical input.
Number.TanhThis function calculates the hyperbolic tangent of a given numerical value.
Number.ToTextThis function converts a numerical value into a text value based on the specified format. The format parameter is a text value that determines how the number will be converted. More information on the...
Percentage.FromThis function calculates a percentage based on the input value. If the input value is empty, the function will return an empty value. If the input value is a text with a percentage symbol at the end, ...
Single.FromThe function Single.From returns a numeric value from the input provided. If the input is null, the function returns null. If the input is a number within the acceptable range for a Single value, that...