DAX Math & Trigonometric - INT function

Description

Rounds a number down to the nearest integer.

Syntax

INT (<number>) 

Parameters

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.