Table of contents
TOC
Collapse the table of content
Expand the table of content

FLOOR Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

Rounds a number down, toward zero, to the nearest multiple of significance.

Syntax

FLOOR(<number>, <significance>)  

Parameters

TermDefinition
numberThe numeric value you want to round.
significanceThe multiple to which you want to round. The argumentsnumber and significance must either both be positive, or both be negative.

Return Value

A decimal number.

Remarks

If either argument is nonnumeric, FLOOR returns #VALUE!error value.

If number and significance have different signs, FLOOR returns the #NUM!error value.

Regardless of the sign of the number, a value is rounded down when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.

Example

The following formula takes the values in the [Total Product Cost] column from the table, InternetSales.and rounds down to the nearest multiple of .1.

=FLOOR(InternetSales[Total Product Cost],.5)  

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

ValuesExpected Result
10.842310.8
8.03738
2.97332.9

See Also

Math and Trig Functions (DAX)

© 2018 Microsoft