Understand Number Functions in Power Query M Language, useful when performing operations on numerical data in data analytics tasks. This page provides a comprehensive list and descriptions of Number Functions available in the M Language.
Table of contents Bitwise Operation Functions
Function Description Input Output Number.BitwiseAnd Returns the result of performing a bitwise “And” operation between the two inputs. Number Number Number.BitwiseNot Returns a byte where each bit is the opposite of the input. Any Any Number.BitwiseOr Returns the result of performing a bitwise “Or” between the two inputs. Number Number Number.BitwiseShiftLeft Shifts the bits set to the left. Number Number Number.BitwiseShiftRight Shifts the bits set to the right. Number Number Number.BitwiseXor Returns the result of performing a bitwise “XOR” (Exclusive-OR) between the two inputs. Number Number
Creation and Conversion Functions
Function Description Input Output Byte.From Creates an 8-bit integer from the given value. Any Number Currency.From Returns a currency value from the given value. Any Number Decimal.From Creates a Decimal from the given value. Any Number Double.From Creates a Double from the given value. Any Number Int16.From Creates a 16-bit integer from the given value. Any Number Int32.From Creates a 32-bit integer from the given value. Any Number Int64.From Creates a 64-bit integer from the given value. Any Number Int8.From Creates a signed 8-bit integer from the given value. Any Number Number.From Creates a number from the given value. Any Number Number.FromText Creates numbers from common text formats (“15”, “3,423.10”, “5.0E-10”). Text Number Number.ToText Formats the given number as text. Number Text Percentage.From Returns a percentage value from the given value. Any Number Single.From Creates a Single from the given value. Any Number
Function Description Input Output Number.IsEven Indicates if the value is even. Number Logical Number.IsNaN Indicates if the value is NaN (Not a number). Number Logical Number.IsOdd Indicates if the value is odd. Number Logical
Mathematical Operations
Function Description Input Output Number.Abs Returns the absolute value of the number. Number Number Number.Combinations Returns the number of unique combinations. Number Number Number.Exp Raises e to the given power. Number Number Number.Factorial Returns the factorial of the number. Number Number Number.IntegerDivide Divides two numbers and returns the integer portion of the result. Number Number Number.Ln Returns the natural logarithm of the number. Number Number Number.Log Returns the logarithm of the number to the specified base (default e). Number Number Number.Log10 Returns the base 10 logarithm of the number. Number Number Number.Mod Integer divides two numbers and returns the remainder. Number Number Number.Permutations Returns the number of permutations. Number Number Number.Power Raises a number to the given power. Number Number Number.Sign Returns 1 if the number is positive, -1 if it is negative, and 0 if it is zero. Number Number Number.Sqrt Returns the square root of the number. Number Number
Random Number Generation Functions
Rounding Functions
Trigonometric Functions
Function Description Input Output Number.Acos Returns the arccosine of the number. Number Number Number.Asin Returns the arcsine of the number. Number Number Number.Atan Returns the arctangent of the number. Number Number Number.Atan2 Returns the arctangent of the division of the two numbers. Number Number Number.Cos Returns the cosine of the number. Number Number Number.Cosh Returns the hyperbolic cosine of the number. Number Number Number.Sin Returns the sine of the number. Number Number Number.Sinh Returns the hyperbolic sine of the number. Number Number Number.Tan Returns the tangent of the number. Number Number Number.Tanh Returns the hyperbolic tangent of the number. Number Number
