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)

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!

 

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

3 Replies

  • 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
     
  • 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]
)
  • ERD's avatar
    ERD
    Community 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.