# INTDAX 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 value of any type.

An integer value of Integer or Currency data type, depending on the argument data type.

## Remarks

INT performs a type conversion to an integer and always returns an integer value.
If <Number> is an Integer or a Decimal data type data type, then the result is an Integer data type.
If <Number> is a Currency, then the result is also a Currency data type.
Other rounding functions (such as TRUNC) return a Decimal data type.

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.

» 2 related articles
» 2 related functions

## 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
```
```--  INT converts any expression in an integer
EVALUATE
{
( "Integer 1", INT ( 10 ) ),
( "Integer 2", INT ( TRUE ) ),
( "Integer 3", INT ( "1950.00" ) ),
( "Integer 4", INT ( 190.89876 ) ),
( "Integer 5", INT ( "1E6" ) )
}
```
Value1 Value2
2001-01-01 10
2001-02-01 1
2001-03-01 1,950
2001-04-01 190
2001-05-01 1,000,000

## Related functions

Other related functions are:

Last update: Jul 19, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

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

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of INT? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.