Assigning shift based on live timing - SQL

Hello All,   Im trying to map the shift based on the timings that are being arrived from backend of SQL data and i have used this formula ( shift = MAXX(filter('Table (2)',Table[datetime]>='Table...