TRUNC DAX Function

The TRUNC 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.

DAX

Example: Create a calculated column.

DAX