Hi,
I am needing to create a formula that specifies what shift a person is working that week in text. Shifts are rotated weekly and the direction is Early > Flexible > Lates and then looping back around.
Each person works the next shift the week after. For example, Bob is working Early one week, the next he works Flexible, then Lates, then Early again, etc.
I would like some help creating a formula that specifies what shift an individual is working this week. It should display like the below -
Is this possible at all? I am fairly new to creating these types of complex formulas and could use a hand. My end goal is to implement this formula into a Power BI report, if that helps.
Thanks,
Callum
Bookmarks