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]
)
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

did you create it as a calculated column?

Try the following calculated column:

List Price = LOOKUPVALUE( 'Product'[List price], 'Product'[Product], Retail[Product] )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution āœ”ļø and give it a thumbs up šŸ‘
 
Best regards
Denis