Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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!
Here we go:
https://drive.google.com/drive/folders/16u-sHErzh1KqNejzjVmbXk7EBs-15XRd?usp=sharing
Thank you!!
@Tumbleweed ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |