Forum Discussion
Solved
Lookup Value Result is duplicate to the same ID
Hi All, I Have a problem with Lookup Value, Star vehicle = LOOKUPVALUE('users'[starInfo.currentVehicle],'users'[_id],'deliveries_attempts'[attempts.star._id]) I am searching for a vehicle f...
You can use below
=LASTNONBLANK(SELECTCOLUMNS(FILTER(users,users[_id]=deliveries_attempts[attempts.star._id]),"abc", users[starInfo.currentVehicle]),1)
Thank you 😄