INT DAX Function (Math and Trig)
Rounds a number down to the nearest integer.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The number you want to round down to an integer. |
Return values
An integer value
Remarks
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.
Examples
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
Related articles
Learn more about INT in the following articles:
-
Choosing Numeric Data Types in DAX
A data model for DAX has three numeric data types: integer, floating point, and fixed decimal number. This article describes them and explains why the fixed decimal number should be used instead of the floating point in most scenarios. » Read more
Related functions
Other related functions are:
Last update: Nov 20, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/int-function-dax