Downloads
DAXMathIntermediate

CEILING

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

Syntax
CEILING(<number>, <significance>)

Returns: A number (a scalar).

What it does

CEILING rounds a number up to the nearest multiple of a value you choose. It is the upward counterpart of FLOOR. Where ROUNDUP works on decimal places, CEILING works on steps, such as the nearest 1,000 dollars or the next 15-minute block. Use it when a figure must be covered in full steps and a partial step still costs a full step.

Syntax and arguments

Example

A department requests funding for a project. The finance team asks for the budget in whole thousands, rounding each request up so the approved amount covers the need.

Budget Request = CEILING([Required Funding], 1000)

A need of 48,250 dollars becomes a request of 49,000 dollars. The extra amount is a buffer that the controller can see and approve.

Example: a second, different use

Bill a client for consulting time in whole 15-minute blocks, always rounding a partial block up:

Billed Hours = CEILING([Logged Minutes], 15) / 60

A time entry of 47 minutes is billed as 60 minutes, which is one full hour. Use FLOOR when the firm rounds down instead.

Things to watch

In business terms

CEILING is used for billing increments, budget requests in round thousands, purchase quantities in full packs, and any allowance that must cover a whole step. It makes sure a plan is funded in units the approver recognizes.

Related functions

All DAX functions · View as Markdown · DAX fundamentals