How does the ISO.CEILING function (DAX) work?

ISO.CEILING function (DAX) Rounds up a number, to the nearest integer or to the nearest significant multiple.

ISO.CEILING Formula Syntax

ISO.CEILING(<number>[, <significance>]) 

How do you use the ISO.CEILING function?

It returns a rounded number to the nearest integer or to the nearest relevant multiple. It works whether the given number is positive or negative.

Related Blog Posts

Related Support Forum Posts

Accessing Matrix hierarchy levels
Dynamic RANKX with Other Category
Developing Complex Dax functions

Considerations when using the ISO.CEILING function

DAX has two CEILING functions −

  • CEILING − Same as the Excel CEILING function.
  • ISO.CEILING − Follows the ISO-defined behavior for determining the ceiling value.

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 ISO.CEILING function


Related DAX Functions


Related Course Modules

Center of Excellence


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide