Forum Discussion
TravisK911
4 years agoFrequent Visitor
Creating a 2-2-3 Schedule in Power Query
I have a table with dates in it and I need to assign either an "A" or "B" to the dates based on a pitman or "2-2-3" schedule. For example: Monday = A Tuesday = A Wednesday = B Thursday = B Frid...
- 4 years ago
There are probably a few ways to do this, but this uses the ribbon almost exclusively without generating lists.
Here is what I did:
- Created a table of the letters, all 14.
- Added an index starting at 0 to it. So they are numbered 0-13.
- From my dates, starting with Monday, created another list going out several month.
- Added an index starting at 0
- Took the modulus of the index divided by 14. This returned a repeating sequence of 0-13 through infinity.
- Merged this with the table of my letters in steps 1/2 above.
My file is here if you want to take a look at it.
wdx223_Daniel
4 years agoCommunity Champion