Number.RoundUp

This function calculates and returns the rounded value of a given number to the nearest whole number. If the input number is null, the function will return null. Additionally, if a specific number of ...

Syntax

Number.RoundUp(number as nullable number, optional digits as nullable number) as nullable number

About

This function calculates and returns the rounded value of a given number to the nearest whole number. If the input number is null, the function will return null. Additionally, if a specific number of decimal digits is provided, the function will round the number to the specified number of digits after the decimal point.

Explanation

Example 1: Take the number 1.234 and round it up to the nearest integer using Power Query MNumber.RoundUp function. The output will be 2. Example 2: Use Power Query MNumber.RoundUp function to round up the number 1.999 to the nearest integer. The output will be 2. Example 3: In Power Query M, use the Number.RoundUp function to round up the number 1.234 to two decimal places. The output will be 1.24.