FLOOR DAX Function

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance, and returns a decimal number.

DAX Syntax FLOOR(Number, Significance)

The function has the following parameters:
• Number: The numeric value we want to round.
• Significance: The multiple to which we want to round.

Note: The arguments number and significance must either both be positive, or both be negative.

Example 1: The following formula takes the values in the [Decimals] column from the table, ‘Table Decimals’, and rounds down to the nearest multiple of .4.

DAX

The following table shows the expected results for some sample values:

Example 2: Create a measure.

DAX