How to filter nightshift overlappen in next day. ?

[Slikvikdk]

Hey,

I'm trying to filter our nightshift so shift start sunday 19:35 and ends monday 06:30 is "Sunday" an so on.

Example. shift start Wednesday 16-02-2022 23:15 and ends Thursday 17-02-2022 06:30 two top rows.

How can i filter so when i choose 16-02-2022 in slicer it takes from 23:15-06:30 and leaves out 16-02-2022 00:00:00 - 16-02-2022 06:30:00??

Hope you guys can help me.

Day shift:

06:30-15:00 Mon-Thursday

06:00 - 12:20 Friday

Evening shift: 15:00 - 23:15 Mon-Wednesday

Thursday 15:00 - Friday 02:05

Night shift:

Sunday 19:35 - Monday 06:30

Monday 23:15 - Tuesday 06:30 

Tuesday 23:15 - Wednesday 06:30

Wednesday 23:15 - Thursday 06:30

[v-yalanwu-msft]

Hi, @Slikvikdk ;

Can you share some simple data and show the results you want to output?

 It makes it easier to give you a solution.

Looking forward to your reply!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,

I encountered a similar challenge yesterday. As a solution I recommend creating this kind of "date2" column that will place the nightshift to previous date if it has value before a certain time:

testable =

SUMMARIZE(

SUMMARIZE(Table,Table[Name],Table[Shift],Table[Date],Table[startTime]Table[Machine],"Date2",IF(timevalue(format(Table[StartTime],"hh:mm:ss"))<timevalue("12:00:00") && Table[Shift] = "Night-shift",Table[Date]-1,Table[Date]),"empCount",1,

,[Date2],[empCount],Table[Shift],Table[Machine],"Time",[empCount]*8)

This will return one day prior for night-shifts ending before 12am.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/