Number functions
Number functions functions for Power Query M language.
Functions
Function | Description |
---|---|
Byte.From | The 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.From | This 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.From | This 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.From | The 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.From | The 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.From | The 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.From | The 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.From | The 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.Abs | This 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.Acos | The function retrieves the arccosine value of a given number. |
Number.Asin | This function calculates and returns the inverse sine of a given numerical value. |
Number.Atan | This function calculates and returns the arctangent of a given number. |
Number.Atan2 | The function calculates the angle, measured in radians, whose tangent is the ratio of two numbers y and x. |
Number.BitwiseAnd | This function calculates the outcome of applying a bitwise "And" operation to number1 and number2. |
Number.BitwiseNot | This function returns the outcome of applying a bitwise negation operation to a numerical value. |
Number.BitwiseOr | This function computes the bitwise "Or" operation between number1 and number2, resulting in a new value. |
Number.BitwiseShiftLeft | Returns the output after shifting the binary representation of number1 to the left by the specified number of bits provided in number2. |
Number.BitwiseShiftRight | This function will calculate the result of a bitwise shift to the right on number1, by the specified number of bits number2. |
Number.BitwiseXor | This function calculates the bitwise XOR operation between two numbers, number1 and number2, and returns the result. |
Number.Combinations | This 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.Cos | This function calculates and returns the cosine value of a given number. |
Number.Cosh | This function calculates and returns the hyperbolic cosine value of a given number. |
Number.Exp | This 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.Factorial | This function will calculate and return the factorial of a given number. |
Number.From | This 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.FromText | Retrieve 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.IntegerDivide | The 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.IsEven | This 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.IsOdd | This function determines whether a given value is odd. It will return true if the number is odd, and false if it is not. |
Number.Isnull | This 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.Ln | This function calculates the natural logarithm of a given number. If the number is null, the function will also return null. |
Number.Log | This 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.Log10 | This function calculates the base 10 logarithm of the input number. If the input number is null, the function will also return null. |
Number.Mod | The 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.Permutations | Returns 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.Power | Returns 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.Random | Generates a random decimal number within the range of 0 to 1. |
Number.RandomBetween | This function generates a random number within a specified range of values, defined by the bottom and top parameters. |
Number.Round | This 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.RoundAwayFromZero | This 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.RoundDown | This 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.RoundTowardZero | This 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.RoundUp | This 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.Sign | The 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.Sin | This function calculates and outputs the sine value of a given number. |
Number.Sinh | This function calculates the hyperbolic sine of a given number. |
Number.Sqrt | The 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.Tan | Returns the value of the tangent function applied to a given numerical input. |
Number.Tanh | This function calculates the hyperbolic tangent of a given numerical value. |
Number.ToText | This 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.From | This 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.From | The 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... |