Forum Discussion
2-2-3 Shift Matrix
I currently have data that I need to break down by shift.
We have 4 shifts, A,B,C,D. A/B are day shifts, and C/D are night shifts. A/C shifts work together days/nights and B/D work together days/nights. We are on a 2-2-3 schedule and Jan. 1 this year was an A/C day. Shifts run from 7am-7pm and 7pm-7am.
Is there a query I can use to automatically create a date table, similar to the result from this thread?
I'd like to create a slicer/filter and see data for each shift.
1 Reply
Locc , I think first you need to create period of 7 week and then further split, Like we have done for 4-4-5
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
