Downloads
DAXMathIntermediate

FLOOR

Rounds a number down to the nearest multiple of a significance value.

Syntax
FLOOR(<number>, <significance>)

Returns: A number (a scalar).

What it does

FLOOR rounds a number down to the nearest multiple of a value you choose. Where ROUNDDOWN works on decimal places, FLOOR works on steps: rounding to the nearest 0.25, the nearest 5 dollars or the nearest 1,000 units. Use it when a price, a block size or a billing increment must land on a set step below the original number.

Syntax and arguments

Example

The pricing team sets retail prices that must end in a multiple of 5 cents. The calculated price is rounded down to the nearest 0.05 so the posted price is never above the approved ceiling.

Posted Price = FLOOR(Product[UnitPrice], 0.05)

A calculated price of 12.37 becomes 12.35. The list stays on the approved grid, and the price does not exceed the figure the team approved.

Example: a second, different use

Bill a service in whole blocks of 15 minutes, dropping any partial block:

Billable Hours = FLOOR([Logged Minutes], 15) / 60

A time entry of 47 minutes becomes 45 minutes, which is 0.75 hours. Use CEILING instead if partial blocks must be billed.

Things to watch

In business terms

FLOOR is used for price points, billing blocks, container sizes, budget steps and any rule where an amount must fit a grid. Finance teams use it in pricing reviews, professional services billing and procurement, where the grid is part of the contract.

Related functions

All DAX functions · View as Markdown · DAX fundamentals