CEILING Function (DAX)

How does the CEILING function (DAX) work?

The CEILING function (DAX) rounds a number up, to the nearest integer or to the nearest multiple of significance.

CEILING Formula Syntax

CEILING(
     <number>, <significance>
)

How do you use the CEILING function?

There are two CEILING functions in dax:

CEILING − Same as the Excel CEILING function.

ISO.CEILING − Follows the ISO-defined behavior for determining the ceiling value.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CEILING function

Both DAX CEILING and ISO.CEILING functions return the same value for positive numbers. However, they return different values for negative numbers.

When using a positive multiple of significance, both CEILING and ISO.CEILING round negative numbers upward (toward positive infinity).

When using a negative multiple of significance, CEILING rounds negative numbers downward (toward negative infinity), while ISO.CEILING rounds negative numbers upward (toward positive infinity).

Related Video Tutorials

Formula examples using the CEILING function

=CEILING(4.42,0.05)

=CEILING([ProductPrice],0.05)

= CEILING(4.6,1) returns 5.

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.