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 from the Users Table to be Shown in deliveries attempts Table
but the problem is for every ID I got two rows
1st is Blank
2nd is the correct result
And the below is the result
I am searching for a vehicle from the Users Table to be Shown in deliveries attempts Table
but the problem is for every ID I got two rows
1st is Blank
2nd is the correct result
And the below is the result
Can someone please support
You can use below
=LASTNONBLANK(SELECTCOLUMNS(FILTER(users,users[_id]=deliveries_attempts[attempts.star._id]),"abc", users[starInfo.currentVehicle]),1)
2 Replies
You can use below
=LASTNONBLANK(SELECTCOLUMNS(FILTER(users,users[_id]=deliveries_attempts[attempts.star._id]),"abc", users[starInfo.currentVehicle]),1)Thank you 😄
