Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Lookupvalue function returns error

Hello   I'm trying to lookup value (list prise) in one input table: and merge it with the following table to get the following resul table (list price is the same ragardless the date)...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Check your 1st table for duplicate values  in product column. you try the following as well:

    ListPrice = 
MAXX(
    FILTER(
        table-1,
        table-1[product]=EARLIER(table-2[product])
    ),
    table-1[List Price]
)
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

What formula did you use?

Here is an example for a measure:

#lookupLP = 
LOOKUPVALUE(InputTable[LP], InputTable[Product], MAX(FollowingTable[Product]))

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.