Forum Discussion

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
6 years ago

Shift Slicer

I have read some threads but it did not solve my problem.

 

We have 2 shifts in manufacturing.

Morning Shift : 6am - 6pm same day

Night Shift : 6pm today - 6am next day

 

What I have in my Data are

1. Scan Start Date Time dd/mm/yyyy hh:mm:ss

2. Scan End Date Time dd/mm/yyyy hh:mm:ss

 

Can Anyone give insights or solutions to this? It will be highly appreciated.

Thank you

4 Replies

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion

      Sorry I didn't notice that I did not disclose what I need.

      Yes, Slicer for 2 shifts is What I am lookin for.

      • v-diye-msft's avatar
        v-diye-msft
        Icon for Community Support rankCommunity Support

        Ok, would you mind sharing your simple worksheet or preferable dummy pbix?

        Also, please let me know how would you like to set the logic? For example, if the manufacturing time starts at 10:00 a.m to 22:00 p.m, which shift should belong to?