Dynamic values in slicer

Hi All,

I've one table where shift details are there- morning, afternoon and evening with there shift start and shift end times

I've one other table where time is mentioned in one column. 

My requirement is, if those times fall under whatever shift timings in a seperate column it should give "Current Shift", otherwise original shift name.

For eg, if times mentioned as 2pm in that column,and it's matching with my current time zone and it lies between afternoon shift timings then in a seperate column it will give "Current shift" and for others it will give either morning or night as per the timings.

Can we achieve that?

@amitchandak @Idrissshatila @parry2k @Greg_Deckler @Ahmedx @Ashish_Mathur @JoeBarry