Rounds a number down to the nearest integer.
The number you want to round down to an integer.
An integer value
INT performs a type conversion to integer and always returns an integer, whereas other rounding functions (such as TRUNC) returns a decimal.
INT rounds <Number> towards −∞ to the nearest integer. If <Number> is already an integer, no rounding occurs. This operation is the same as taking the integer part of <Number>, but only when <Number> is non-negative.
The following examples clarify the behavior of INT with negative and positive numbers.
INT ( - 2.9 ) = -3 INT ( - 2.1 ) = -3 INT ( - 0.9 ) = -1 INT ( - 0.1 ) = -1 INT ( 0.1 ) = 0 INT ( 0.9 ) = 0 INT ( 2.1 ) = 2 INT ( 2.9 ) = 2
Learn more about INT in the following articles:
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/int-function-dax