MOD Function (DAX)

Sam McKay February 12, 2020 No Comments

How does the MOD function (DAX) work?

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

MOD Formula Syntax

= MOD(
<number>, <divisor>
)

How do you use the MOD function?

The MOD function can be expressed in terms of the INT function: MOD(n, d) = n – d*INT(n/d)

Considerations when using the MOD function

If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.

Formula examples using the MOD function

Example 1

The following formula returns 1, the remainder of 3 divided by 2.

= MOD (
3,2
)

Example 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.

= MOD (
-3, -2
)

Related DAX Functions

Related Course Modules

“I truly appreciate your efforts in helping the ones who needed to get more professional help in using Power BI. Your videos are A+ and really helpful+inspiring for me. I wish you the best from Turkey.”

Erol Yücel

“I have taken couple of courses from Sam from Enterprise DNA. I really liked the course. Its well explained, organized and importantly all the datas and formulas & even dashboards are available for everyone.”

Mahesh T, London

“Enterprise DNA has greatly increase my ability to report within our company forever. I went from knowing nothing about Power BI to using it on a daily basis in 30 days simply by watching Sam’s videos & executing his technique.”

Geoff Ellis

“Sam has a very hands-on approach to his training, and is always willing to help! Been apart of several different DAX classes, & Sam’s training is by far the best I have come across.”

Matt Ballinger

“I am really thankful to Sam for helping me through the Power BI. I was a newbie and his hands-on approach and business-oriented approach is all we need. Great work Sam. Keep going!”

Sourabh

“Thanks to Enterprise DNA training! I have improved my Power BI tool skills and have a deeper understanding of data analytics. Sam does an excellent job teaching and problem-solving.”