Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to pass a variable using LOOKUPVALUE

I'm currently trying to pull a value from a different row in a table using the LOOKUPVALUE command but I'm encountering a problem.   Landmark = VAR trailerid = 'Table'[Trailer ID] RETURN LOOKUPVA...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try

minx(filter('Table','Table'[Index] = earlier( 'Table'[Index Prior]) && 'Table'[Trailer ID] = "8543"),'Table'[Landmark])

Or

minx(filter('Table','Table'[Index] = earlier( 'Table'[Index]) && 'Table'[Trailer ID] = "8543"),'Table'[Landmark])