Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
DAX
MOD(<number>, <divisor>)
| Term | Definition |
|---|---|
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. |
A whole number.
If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.
The MOD function can be expressed in terms of the INT function: MOD(n, d) = n - d*INT(n/d)
The following formula returns 1, the remainder of 3 divided by 2.
DAX
= MOD(3,2)
The following formula returns -1, the remainder of 3 divided by 2. Note that the sign is always the same as the sign of the divisor.
DAX
= MOD(-3,-2)
Math and Trig functions ROUND function ROUNDUP function ROUNDDOWN function MROUND function INT function