ROUNDUP - Daxplained

ROUNDUP is a DAX function that rounds a number up away from zero to the nearest integer or specified significance.

Syntax

ROUNDUP(
   Number,
   NumberOfDigits
)

Argument	Properties	Description
Number		Any real number that you want rounded up.
NumberOfDigits		The number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer.

A decimal number.

If num_digits is greater than 0 (zero), then the number is rounded up to the specified number of decimal places.
If num_digits is 0, then number is rounded up to the nearest integer.
If num_digits is less than 0, then number is rounded up to the left of the decimal point.
ROUNDUP behaves like ROUND, except that it always rounds a number up.

The following formula rounds Pi to four decimal places. The expected result is 3.1416.

= ROUNDUP(PI(),4)

The following formula rounds 1.3 to the nearest multiple of 0.2. The expected result is 2.

= ROUNDUP(1.3,0.2)

The following formula rounds the value in the column, FreightCost, with the expected results shown in the following table:

= ROUNDUP([Values],-1)

When num_digits is less than zero, the number of places to the left of the decimal sign is increased by the value you specify.

Other functions related to ROUNDUP are:

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