Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Lookup value - error multiple values was supplied

Hi all,    I tried to create a calculated column from the left table to lookup value from the right table but it shows this error "A table of multiple values was supplied where a single value was e...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Does this work?

    CALCULATE(SUM('USA recurring'[USD revenue]),FILTER('USA recurring','USA recurring'[Customer ID]=EARLIER('monthly groupby'[customer_id])&&'USA recurring'[Year billed]=EARLIER('monthly groupby'[year])&&'USA recurring'[month billed converted]=EARLIER('monthly groupby'[month])))

akhilduvvuru's avatar
akhilduvvuru
Helper IV
3 years ago

Ashish_Mathur v-juanli-msft - I have a similar requirement where I have to just bring multiple values from other table using Lookup value function.

When I use LOOKUPVALUE, I'm getting this error: "A table of multiple values was supplied where a single value was expected"
When I use FIRSTNONBLANK, I getting only one value from the other table. However I need all the matched values (few cases only 1 value, few cases more than 1).

 

Can you please help me with the same? Thanks!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Both those functions will only bring over a single value.  To bring over multiple values (in multiple rows), use the Query Editor to merge the two tables.