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 of Integer or Currency data type, depending on the argument data type.
Remarks
INT performs a type conversion to an integer and always returns an integer value.
If <Number> is an Integer or a Decimal data type data type, then the result is an Integer data type.
If <Number> is a Currency, then the result is also a Currency data type.
Other rounding functions (such as TRUNC) return a Decimal data type.
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.
» 2 related functions
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
-- INT converts any expression in an integer
EVALUATE
{
( "Integer 1", INT ( 10 ) ),
( "Integer 2", INT ( TRUE ) ),
( "Integer 3", INT ( "1950.00" ) ),
( "Integer 4", INT ( 190.89876 ) ),
( "Integer 5", INT ( "1E6" ) )
}
| Value1 | Value2 |
|---|---|
| 2001-01-01 | 10 |
| 2001-02-01 | 1 |
| 2001-03-01 | 1,950 |
| 2001-04-01 | 190 |
| 2001-05-01 | 1,000,000 |
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
-
Differences between INT and CONVERT in DAX
This article describes the small differences between INT and CONVERT in DAX that may end up returning different results in arithmetic expressions. » Read more
Related functions
Other related functions are:
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/int-function-dax