Forum Discussion
Shift model
I would like to divide the work day into early (6 am- 2 pm), late (2 pm- 10 pm) and night shifts (10 pm- 6 am). As you can see in the pictures. Creating the night shift is no problem because it run...
Hi Anonymous,
I think for me it's clear enough.
To Solve your Problem in Power query is realy hard - in Dax it would be a bit easier.
You don't need your calculated Dates column to solve it because you have the dates in the data Table.
The only Problem I have is how to decide if the person is in Group A or B.
Because of that i can't give you an exact solution.
May be you can share your table were the person is shown in which group he/she is.
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!