Dear Power BI Community,
I'm building a report to count penalties for too short (less than 30 minutes) or missed lunch breaks. The dataset has data on how long hours were and was it a break. I need to calculate a break less than 30 minutes, no break over 5 hours, no break over 10 hours. So, I use the following logic:
1. CC Break < 30 = IF(Table1[is_break] = 1 && Table1[hours] < 0.5, 1, 0)
M < 30 Break =
VAR thirty_break =
SUMX(VALUES(Table1[company]),
SUMX(VALUES(Table1[position]),
SUMX(VALUES(Table1[employee]),
CALCULATE(MAX(Table1[CC Break < 30])))))
RETURN IF (thirty_break = 0, BLANK(), thirty_break)
2. > 5 hr No Break = IF(Table1[is_break] = 0 && Table1[hours] > 5, 1, 0)
M > 5 hr No Break =
VAR five_hours_break =
SUMX(VALUES(Table1[company]),
SUMX(VALUES(Table1[position]),
SUMX(VALUES(Table1[employee]),
CALCULATE(MAX(Table1[> 5 hr No Break])))))
RETURN IF (five_hours_break = 0, BLANK(), five_hours_break)
3. > 10 hr No Break = IF(Table1[is_break] = 0 && Table1[hours] > 10, 1, 0)
M > 10 hr No Break =
VAR ten_hours_break =
SUMX(VALUES(Table1[company]),
SUMX(VALUES(Table1[position]),
SUMX(VALUES(Table1[employee]),
CALCULATE(MAX(Table1[> 10 hr No Break])))))
RETURN IF (ten_hours_break = 0, BLANK(), ten_hours_break)
Now, I need to calculate penalties per day: 1 penalty for too short break or 1 penalty for missed break over 5 hours;
2 penalties for too short break and not taking another break within next 5 hours; 2 penalties for not taking break over 10 hours of work. What will be the best way to calculate penalties?
Thanks in advance!
