# 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

Floor column = FLOOR('Table Decimals'[Decimals], 0.4)

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

Example 2: Create a measure.

DAX

FLOOR measure = FLOOR(1056.35678, .3)