Downloads
DAXMathBeginner

ROUNDDOWN

Rounds a number down, toward zero, to a set number of digits.

Syntax
ROUNDDOWN(<number>, <num_digits>)

Returns: A number (a scalar).

What it does

ROUNDDOWN always rounds toward zero. For a positive number, that means down. It is useful when an estimate should be conservative, or when only whole units are payable and any fraction must be dropped. ROUNDDOWN is the counterpart of ROUNDUP.

Syntax and arguments

Example

The FP&A team sets a conservative revenue forecast for the board. Forecast revenue is rounded down to the nearest thousand dollars, so the stated figure never overstates what is expected.

Forecast For Board = ROUNDDOWN([Forecast Revenue], -3)

A forecast of 1,234,567 dollars is shown as 1,234,000. The rule is easy to explain to the board, and the figure is never higher than the model.

Example: a second, different use

Whole full-time equivalents that can be funded from a fixed budget, where a part-time fraction cannot be paid:

Fundable Positions = ROUNDDOWN([Budget Hours] / [Hours Per Position], 0)

The result is the number of complete positions the budget covers. The leftover hours are not enough to hire anyone.

Things to watch

In business terms

ROUNDDOWN is the rule for conservative forecasts, funded positions, whole-unit purchasing and any amount that the business cannot pay beyond what is available. Write the rule down in the model documentation so the board and the auditor read it the same way.

Related functions

All DAX functions · View as Markdown · DAX fundamentals