Tutorial with example
QUOTIENT function performs a division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.
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 QUOTIENT 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 either argument is non-numeric, QUOTIENT returns the #VALUE! error value.
You can use a column reference instead of a literal value for either argument. However, if the column that you reference contains a 0 (zero), an error is returned for the entire column of values.