DAX function
INT — DAX function reference
Truncate to an integer.
Syntax
dax
INT(<number>)
Examples
dax
INT([Value])
→ A whole number
dax
INT(DATEDIFF(Sales[OrderDate], Sales[ShipDate], DAY) / 7)
→ Whole weeks between order and ship date
dax
INT([Total Sales] / [Target]) * 100
→ Truncated percent-of-target, dropping the decimal instead of rounding
Common mistakes & gotchas
- INT always truncates toward negative infinity (like FLOOR), not toward zero — INT(-2.5) is -3, not -2, which surprises anyone expecting simple decimal truncation; account for sign explicitly in variance or delta calculations.
Related DAX functions
From Math & statistics