Number.RoundUp is a Power Query M function that rounds a given number up to the next highest integer, with support for optional digits parameter. The function returns the rounded number or null if the input is null.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Number.RoundUp(
number as nullable number,
optional digits as nullable number,
) as nullable numberDescription
Returns the result of rounding number up to the next highest integer. If number is null, this function returns null.
If digits is provided, number is rounded to the specified number of decimal digits.
Examples
Round up 1.234 to integer.
// Output: 2
Number.RoundUp( 1.234 )Round up 1.999 to integer.
// Output: 2
Number.RoundUp( 1.999 )Round up 1.234 to two decimal places.
// Output: 1.24
Number.RoundUp( 1.234, 2 )Related functions
Other functions related to Number.RoundUp are:
