ROUNDUP Function (DAX)

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 Blog Posts

Related Support Forum Posts

Measures not calculating sum in matrix
Financial Week Help Please
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.

Related Video Tutorials

Formula examples using the ROUNDUP function

=ROUNDUP(PI(),4)

=ROUNDUP(1.3,0.2)

=ROUNDUP([Values],-1)

Related DAX Functions

ROUND
INT
MROUND
ROUNDDOWN

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.