This documentation is archived and is not being maintained.
Number functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference .
Constants Information Conversion and formattingFunction Description Byte.From Returns a 8-bit integer number value from the given value. Currency.From Returns a currency value from the given value. Decimal.From Returns a decimal number value from the given value. Double.From Returns a Double number value from the given value. Int8.From Returns a signed 8-bit integer number value from the given value. Int16.From Returns a 16-bit integer number value from the given value. Int32.From Returns a 32-bit integer number value from the given value. Int64.From Returns a 64-bit integer number value from the given value. Number.From Returns a number value from a value. Number.FromText Returns a number value from a text value. Number.ToText Returns a text value from a number value. Percentage.From Returns a percentage value from the given value. Single.From Returns a Single number value from the given value.
RoundingFunction Description Number.Round Returns a nullable number (n) if value is an integer. Number.RoundAwayFromZero Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0. Number.RoundDown Returns the largest integer less than or equal to a number value. Number.RoundTowardZero Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0. Number.RoundUp Returns the larger integer greater than or equal to a number value.
OperationsFunction Description Number.Abs Returns the absolute value of a number. Number.Combinations Returns the number of combinations of a given number of items for the optional combination size. Number.Exp Returns a number representing e raised to a power. Number.Factorial Returns the factorial of a number. Number.IntegerDivide Divides two numbers and returns the whole part of the resulting number. Number.Ln Returns the natural logarithm of a number. Number.Log Returns the logarithm of a number to the base. Number.Log10 Returns the base-10 logarithm of a number. Number.Mod Divides two numbers and returns the remainder of the resulting number. Number.Permutations Returns the number of total permutatons of a given number of items for the optional permutation size. Number.Power Returns a number raised by a power. Number.Sign Returns 1 for positive numbers, -1 for negative numbers or 0 for zero. Number.Sqrt Returns the square root of a number.
Random Trigonometry Bytes