ISO.CEILING Rounds a number up, to the nearest integer or to the nearest multiple of significance.


ISO.CEILING(number[, significance])


Number – The number you want to round, or a reference to a column that contains numbers.

Significance – (optional) The multiple of significance to which you want to round. For example, to round to the nearest integer, type 1. If the unit of significance is not specified, the number is rounded up to the nearest integer.

Return Value

A number, of the same type as the number argument, rounded as specified.

Reference Data

DAX Functions / Math and Trig Functions / ISO.CEILING