MOD DAX Function (Math and Trig)

Returns the remainder after a number is divided by a divisor.

Syntax

MOD ( <Number>, <Divisor> )

Parameter	Attributes	Description
Number		The number for which you want to find the remainder after the division is performed.
Divisor		The number by which you want to divide.

Scalar A single integer value.

An integer number.

MOD ( 0, 2 ) -- returns 0
MOD ( 5, 2 ) -- returns 1
MOD ( 6, 3 ) -- returns 0
MOD ( 7, 3 ) -- returns 1
MOD ( 8, 3 ) -- returns 2

Learn more about MOD in the following articles:

Applying color banding by document number in Power BI

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of using the alternate rows color formatting option. » Read more

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo