Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
LOOKUPVALUE('Table'[Landmark], 'Table'[Index], 'Table'[Index Prior],'Table'[Trailer ID], trailerid)
Above is the code I've been trying to use but it doesnt work in its current state and I get the error "A table of multiple values was supplied where a single value was expected."
However, when I format like so:
Landmark Prior =
LOOKUPVALUE('Table'[Landmark], 'Table'[Index], 'Table'[Index Prior],'Table'[Trailer ID], "8543")
The above code works properly when formatted manually for the trailer id "8543".
Is there a particular reason why trying to pass a variable through will not work on this code? I can provide more context if necessary, I'm just hoping I did something stupid thats easy to fix at first glance from somebody smarter than me.
Thanks
@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])