MOD

Syntax

MOD(<number>, <divisor>)

Tutorial with example

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

In this video, I am going to show your how to calculate how late are your employees and how much would you discount of the payroll if you had a 2$ fee for each 15 min late using among others MOD function.

Keynotes:
03:00 Calculate how many minutes or hours and employee is late with DATEDIFF function
05:00 Calculate how many 15 minutes interval he is late : QUOTIENT function
10:00 Extract minutes from a time column in DAX: TIMEVALUE and MINUTE funcitons
12:00 Extract decimals from a number with MOD function
13:20 Convert a number to a logical function : true or false with INT function
14:00 Calculate payroll fee if employee is late

Download example files:

Download the pbix and excel file here.

Remarks

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)