Forum Discussion

Davykyndt's avatar
Davykyndt
Frequent Visitor
8 years ago
Solved

Creat column with shift numbers

I have a calendar table where I'd like to add a column with workingshifts. I have 2 working shifts working 7 days for shift A and then 7 days for shift B.   Any idea how I can calculate this basen ...
Need Help
  • Davykyndt's avatar
    Davykyndt
    8 years ago

    Hi I found a solution:

     

    Shiftnr = if((mod(calender[Date]+2;14)+1)<=7;"Shift A"; "Shift B")

     

     

Davykyndt's avatar
Davykyndt
Frequent Visitor
8 years ago

SenShiftday = if((WEEKDAY(calender[Date];2)+3)>7;WEEKDAY(calender[Date];2)-4;WEEKDAY(calender[Date];2)+3)

The shift starts on a day 1 and runs until day 7, after this the next shift starts.

Davykyndt's avatar
Davykyndt
Frequent Visitor
8 years ago

Hi I found a solution:

 

Shiftnr = if((mod(calender[Date]+2;14)+1)<=7;"Shift A"; "Shift B")