CEILING DAX Function

The CEILING function rounds a number up, to the nearest integer or to the nearest multiple of significance, and returns the number rounded as specified.

DAX Syntax CEILING(Number, Significance)

The function has the following parameters:

• Number: The number you want to round, or a reference to a column that contains numbers.
• • Significance: The multiple of significance to which you want to round. For example, to round to the nearest integer, type 1.

Example: Create a calculated column.

DAX