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]
)
Fowmy's avatar
Fowmy
Super User
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]
)