- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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.
dax_functions_mathematical_trigonometric.htm
Advertisements