Forum Discussion
Power BI Create 7 on 7 off Roster for Crews
Hi All,
I am trying to create a shift roster in power bi or power query but have no idea how to approach it.
The roster in 7 on, 7 off. There is a night shift and dayshift crew and they rotate (eg, A crew dayshift, C crew Nightshift for a week, then both get week off, then C crew dayshift, A crew Nightshift).
This is what the outcome should look like:
How do I go about setting up this roster in power BI or powewr query (whichever is easiest).
Thanks!
1 Reply
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
