cancel
Showing results for
Did you mean:
Helper I

## Counting penalties / logic

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?

2 REPLIES 2
Helper I
Super User

@Tumbleweed ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!