TRUNC

TRUNC Truncates a number to an integer by removing the decimal, or fractional, part of the number.


Syntax

TRUNC(number,num_digits)

Parameters

Number – The number you want to truncate.

Num_digits – A number specifying the precision of the truncation; if omitted, 0 (zero)

Return Value

A whole number.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Math and Trig Functions / TRUNC