DAX function
CEILING / FLOOR — DAX function reference
Round to a multiple.
Syntax
dax
CEILING(<number>, <significance>) FLOOR(<number>, <significance>)
Examples
dax
CEILING([Price], 0.05)
→ A number
dax
FLOOR([Unit Price], 0.05)
→ Rounds price down to the nearest 5 cents, e.g. for a price-ending strategy
dax
CEILING(COUNTROWS(Sales) / 25, 1)
→ Number of full batches of 25 needed, always rounding up to a whole batch
Common mistakes & gotchas
- The significance argument must share the same sign as the number being rounded — CEILING(-4.2, 1) errors because -4.2 is negative but 1 is positive; use CEILING(-4.2, -1) instead.
- CEILING/FLOOR round to a multiple of significance, not to a number of decimal places — CEILING(4.3, 0.25) rounds to the nearest quarter (4.5), a fundamentally different tool from ROUND/ROUNDUP despite the superficial similarity.
Related DAX functions
From Math & statistics