Downloads
DAXMathBeginner

ROUNDUP

Rounds a number up, away from zero, to a set number of digits.

Syntax
ROUNDUP(<number>, <num_digits>)

Returns: A number (a scalar).

What it does

ROUNDUP always rounds away from zero, so the result is never less than the input for positive numbers. It is the right choice when a partial unit still needs a full container, a full page or a full payment cycle. Use it for quantities that must be whole and must cover the need.

Syntax and arguments

Example

The warehouse ships units in cases of 12. Each order needs enough full cases to cover the units, so any partial case is rounded up to a whole case.

Cases To Ship = ROUNDUP(Sales[SalesQuantity] / 12, 0)

An order of 25 units needs 3 cases, not 2.08. The count of cases then drives the freight cost, which is priced per case.

Example: a second, different use

A minimum bonus pool must be paid in whole dollars, so the calculated amount is always rounded up to the next dollar:

Bonus Pool = ROUNDUP([Calculated Bonus], 0)

This makes the pool at least the calculated amount, which protects against a shortfall after rounding.

Things to watch

In business terms

ROUNDUP is used for freight by the case, pallet counts, licences or seats that must be bought in whole units, minimum payment amounts and any allocation where a short fraction must be covered. It keeps the plan honest about what is actually needed.

Related functions

All DAX functions · View as Markdown · DAX fundamentals