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 ...
Number.RoundUp(number as nullable number, optional digits as nullable number) as nullable numberThis 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.
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.