Xlookup from string
Dear All, We are getting data in the below format where we are getting Raw value against each point and we need to identify it's state based on the metata in the State column coming in as a string value. E.g. Point ID 1 should have occupancy state as Unoccupied where as Point ID 2 should have occupancy state as Occupied. Expected Values We are dealing with huge timeseries sensors data coming in every 15 minutes. Kindly provide us the logic DAX or Custom column logic which should have minimum performance impact. Also please suggest is this too bad to implement this in Power BI? Thanks!
DAX equivalent of XLOOKUP function in Excel
Is there a way to duplicate the XLOOKUP function in DAX? In my excel file, if the number of photos=0, then I need to look for the next date where the number of photos is greater than 0, and assign the Tier Lookup to the dates prior. The desired result is shown in column I. Thank you!
