Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |