Lookupvalue function returns error

[Anonymous]

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)

However, Lookupvalue formula returns an error "A table with multiple values was returned when a single value was expected". 

Any idea what causes the error and how to solve it?

Thank you!

[ERD]

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.

[Fowmy · Accepted solution]

@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]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic