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.
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: Oct 13, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/int-function-dax