## How does the CEILINGfunction (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.

## CEILINGFormula Syntax

CEILING(
<number>, <significance>
)

## How do you use the CEILINGfunction?

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 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.

## Formula examples using the CEILINGfunction

=CEILING(4.42,0.05)

=CEILING([ProductPrice],0.05)

= CEILING(4.6,1) returns 5.

## Related Course Modules 