Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • v-xuding-msft's avatar
    v-xuding-msft
    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.

  • v-xuding-msft's avatar
    v-xuding-msft
    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.