CEILING Function (DAX)

How does the CEILING function (DAX) work?

There are two parameters to the CEILING function (DAX): the number which is the value you want to round and the significance which is the multiple to which you want to round.   

The CEILING function rounds a number up to the nearest integer or to the nearest unit of significance.  

CEILING Formula Syntax

CEILING(
     <number>, <significance>
)

How do you use the CEILING function?

There are two CEILING functions in DAX: the CEILING function which showcases the same behavior as the Excel CEILING function, and the ISO.CEILING function which follows the ISO-defined behavior when coming up with the ceiling value.

Related Blog Posts

Related Support Forum Posts

Normal Distribution Curve
DAX for a Dynamic Table instead of calculated table
SUMX not calculating correctly

Considerations when using the CEILING function

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

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.