Number.RoundUp

Updated on

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 )

Other functions related to Number.RoundUp are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-roundup