MOD DAX Function in Power BI

The MOD DAX function in Power BI returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.

DAX Syntax MOD(number, divisor)

The function has the following parameters:

• number: The number for which we want to find the remainder after the division is performed.
• divisor: The number by which we want to divide.

Example: The following formula returns 1, the remainder of 32 divided by 3.

DAX

The output of the above code is shown below:

If denominator is 0, MOD function will return an error.

Key Notes:

• If denominator = 0, MOD will return an error.
• Works with both columns and measures.