Forum Discussion
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...
Sairam_11 , This formula seems fine to me for a new column in Table looking into table 2 you have shared above
shift = MAXX(filter('Table (2)',Table[datetime]>='Table (2)'[starttime] && Table[datetime] <='Table (2)'[endtime] ),'Table (2)'[shift])
Can you please share what is wrong? Share data for both tables to test