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 number
Description
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:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy