Assigning Rotating Shift Teams based on Date

johnt75 Thank you again for helping me with the problem. I have been using the solution you proposed creating a helper table to assign rotating shifts based on the date. I have applied this solution several times now with no issue. But for some reason today is giving me a DAX error and is not recognising the column/field that is obviously there. The first line of your DAX picks up the column but the second line does not and i cannot figure out why. I have been stuck on this for very long time now checking everything. Perhaps you can help me figure out where is this wrong now.

**********************************************************************************

Offset =

VAR StartDate = CALCULATE( MIN( 'TeamsShiftRoster'[Production Date] ), REMOVEFILTERS() )

VAR Result = DATEDIFF( StartDate, 'TeamsShiftRoster'[Production Date], DAY )

RETURN Result

******************************************************************************************************

Here is woking well

 

But now when i apply the same strategy that has been working so well before, is now giving me an error

 

I really not sure why is no longer working