Custom roster calendar

Good morning,

I suggest you the following approach:

   1 you create a date column for the period you want

   2 you add a index column to the date table. In your example 3/19/2020 will be 1... 3/18/2021 will have 365

   3 add a custom column to create an increment of 28: if [Index] < 28 then [Index] else if [Index] - (28 * (Number.IntegerDivide([Index], 28))) = 0 then 28 else [Index] - (28 * (Number.IntegerDivide([Index], 28)))

   4 create different shift sequences with 2 columns: colum 1 is index from 1 to 28, 2nd column description of the shift: "D", "RR", N"

   5 Realise a full join on Date and Shift table based on Index column.

Did it answer your question? Please mark my post as solution

Did you like the answer? Please add a kudo.

Good luck and keep up the good job.

Kind regards,

Lohic Beneyzet