Cheat Sheets/Power BI/ROUNDUP / ROUNDDOWN
DAX function

ROUNDUP / ROUNDDOWN — DAX function reference

Round away from / toward zero.

Syntax

dax
ROUNDUP(<number>, <num_digits>)    ROUNDDOWN(<number>, <num_digits>)

Examples

dax
ROUNDUP([Sales], 0)
→ A number
dax
ROUNDUP(DIVIDE(COUNTROWS(Sales), 50), 0)
→ Number of pages needed at 50 rows per page, always rounding up
dax
ROUNDDOWN([Discount %] * 100, 0) / 100
→ Truncates a discount percentage to a whole percent, never rounding up

Common mistakes & gotchas

Related DAX functions

From Math & statistics

Used in these tutorials

← Back to the Power BI (DAX) cheat sheet