TRUNC DAX Function in Power BI
The TRUNC DAX function truncates a number to an integer by removing the decimal, or fractional, part of the number.
DAX Syntax TRUNC(Number, NumberOfDigits)
The function has the following parameters:
- Number: The number we want to truncate.
- NumberOfDigits: A number specifying the precision of the truncation; if omitted, 0 (zero).
Example: Create a calculated column with name “Trun column”.
DAX
Trun column = TRUNC('Table Decimals'[Decimals])
The output of the above dax function is shown below:
Example: Create a calculated column with name “Trun column”.
DAX
Trun column = TRUNC('Table Decimals'[Decimals],2)
The output of the above dax function is shown below:
