INT DAX Function (Math and Trig)

Rounds a number down to the nearest integer.

Syntax

INT ( <Number> )

Parameter	Attributes	Description
Number		The number you want to round down to an integer.

Return values

Scalar A single integer value.

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.

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.

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

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: Jul 1, 2020 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/int-function-dax