Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Solution: https://community.powerbi.com/t5/Desktop/Shift-that-Goes-into-Next-day/m-p/2690043#M941771
Good day community,
I need help, I am trying to sum the total amount of hours worked by each employee, to measeure the complaince, the have a certain amount of hour scheduled. My problem is that could not sum accuratly the hour work by the graveyard agent: They usually start shift at 6.00 pm, 7.00 pm or 9.00 pm. They end the shift the next day but the hours should count in the previous day; which is the nominal day, is there any way to make this possible?
Interval | Hours |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:00 | 1800 |
9/1/2022 0:30 | 1800 |
9/1/2022 0:30 | 1800 |
9/1/2022 0:30 | 1800 |
9/1/2022 0:30 | 1800 |
9/1/2022 0:30 | 0 |
9/1/2022 0:30 | 0 |
9/1/2022 0:30 | 0 |
9/1/2022 0:30 | 0 |
9/1/2022 0:30 | 0 |
9/1/2022 1:00 | 0 |
9/1/2022 1:00 | 0 |
9/1/2022 1:00 | 0 |
9/1/2022 1:00 | 0 |
9/1/2022 1:00 | 0 |
9/1/2022 1:00 | 1800 |
9/1/2022 1:00 | 1800 |
9/1/2022 1:00 | 1800 |
9/1/2022 1:00 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 1:30 | 1800 |
9/1/2022 20:00 | 1800 |
9/2/2022 20:30 | 1800 |
9/3/2022 21:00 | 1800 |
9/4/2022 21:30 | 1800 |
9/5/2022 22:00 | 1800 |
9/6/2022 22:30 | 1800 |
9/7/2022 23:00 | 0 |
9/8/2022 23:30 | 0 |
9/10/2022 0:00 | 0 |
Like Dinesh suggests... if your data was :
emp_id, start_time, finish_time
abc, 01/01/2022 18:00, 02/01/2022 07:00
etc your data would be more "friendly" to work with.
Personally I would look at capturing the start date/time and the end date/time only per user. The difference between the stamps will give you the hours. You can use the start date (trimmed to date) as the label for the work shift. You need a lot less data than what you appear to have there.
I usually split the columns to get the date and the intervals
Hi,
Does this Interval column show start day or end day?
ex in 1st row it shows 9/1/2022 0:00. Is this start day or end day?
Thank you.
9/1/2022 0:00 this is the start day, it is the first segment of the day, what i am looking for is sum the hours based on the nominal day, when they started the shift
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
59 | |
58 |