Power BI Create 7 on 7 off Roster for Crews

[kristyd43]

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!

[edhans]

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.