DAX Function Guide

ISO.CEILING
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISO.CEILING 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?

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

Loading

Considerations when using the ISO.CEILING?

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

Loading

Formula examples using the ISO.CEILING
=ISO.CEILING(-4.42,0.05)
Related Courses

Loading