DAX Math & Trigonometric - INT function
Description
Rounds a number down to the nearest integer.
Syntax
INT (<number>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
number The number you want to round down to an integer. |
Return Value
A whole number.
Remarks
DAX INT and TRUNC functions are similar - both return integers.
INT rounds the numbers down to the nearest integer based on the value of the fractional part of the number.
TRUNC removes the fractional part of the number.
Thus, both INT and TRUNC return same results for positive numbers. For example,
INT (5.3) returns 5 because 5 is the lower number.
TRUNC (5.3) returns 5 as it removes the fractional part.
However, INT and TRUNC return different results for negative numbers. For example,
INT (-4.3) returns -5 because -5 is the lower number.
TRUNC (-4.3) returns -4 as it removes the functional part.
Example
= INT (5.3) returns 5. = INT (-5.3) returns -6.