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