Forum Discussion
Lookupvalue value error
Hello everyone, I was hoping you could help me out. I was trying to do a look up function, but I was getting an error because it has duplicate values. I figured I would try this Calculate but it didn...
Anonymous ,
Try adding additional column in Table2:
Column = CALCULATE( FIRSTNONBLANK(Table2[Mark], Table2[Mark]), ALLEXCEPT(Table2, Table2[Id] ) )
-- Mark is value that i wanted to return in Table1, but there are different marks for same Id.
-- Mark is value that i wanted to return in Table1, but there are different marks for same Id.
-- So i added new column which returns always same Mark for same Id (first occurence)
Now when i return to Table1 where i want to add lookupvalue, i will not search by Table2[Mark], but by my new column which has unique values per Id.
Lookup formula:
Now when i return to Table1 where i want to add lookupvalue, i will not search by Table2[Mark], but by my new column which has unique values per Id.
Lookup formula:
Lookup column = LOOKUPVALUE(Table2[Column],Table2[Id],Table1[Order Number])
I tried that and got too many arguments. So, here is what I am tryining to do, may there is a better way to do it.
In table FedEx Query I want to add a new column that will show a value. I need to use the Shipper Reference column to match the same value in column Pallet_ID in the table called DLX Report Query. That value I need to show in the new column in the table FedEx Query is called Dealer Code in the DLX Report Query. Sorry I am a little new at this, so it a bit confusing.
'FedEx Query'[Shipper Reference] Need too use this number
'DLX Report Query'[PALLET_ID] And Reference this number
'Report Query'[Dealer Code] Need to show this column that has duplicates