Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Splitting Hours by Shift

I am working on a report to track the output of our operators, unforntunately output is recorded by work center and not by operator ID. I am looking for a way to split up these hours by shift. Day shift runs from 6:00 AM to 4:00 PM and night shift runs from 9:00 PM to 6:00 AM. I would like to break this report out by day and by week. Thank you in advance for your help. 

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

Did you implement split hours by shift?  If you have solved it, please share your solutions and accept your answer a solution. Then More people who have the same request will benefit here. If you still need help, please share some sample data and expected results.  We will understand clearly and implement it as soon as possible.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

Can you please share some sample data and your expected results? Then we will understand your requirements clearly and help you as soon as possible.

 

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.