## How does the ROUNDUP function (DAX) work?

The ROUNDUP function (DAX) rounds a number up, away from 0 (zero).

## ROUNDUP Formula Syntax

ROUNDUP(
<number>, <num_digits>
)

## How do you use the ROUNDUP function?

The ROUNDUP function will always round numbers up. The number of places to round to is controlled by the num_digits argument. Positive numbers round to the right of the decimal point, negative numbers round to the left, and zero rounds to the nearest 1.

## Related Support Forum Posts

Measures not calculating sum in matrix
FY week number column

## Considerations when using the ROUNDUP function

ROUNDUP behaves like ROUND, except that it always rounds a number up.

• 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 the number is rounded up to the nearest integer.
• If num_digits is less than 0, then the number is rounded up to the left of the decimal point.

## Formula examples using the ROUNDUP function

=ROUNDUP(PI(),4)

=ROUNDUP(1.3,0.2)

=ROUNDUP([Values],-1)

## Related Course Modules 