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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

I tried your Expression, and it works well on my side.

The column is calculated in Table ‘monthly groupby’. You could try it again.

 

Regarding your error, it is often caused by duplicate values.

For example, 

table a              table b

col1                  col2    col3

a                        a         1

b                        a         2

                          b         3

                          b         4

It may throw an error when we use "lookupvalue" to get value from table b into table a.

 

If so, please consider any other methods.

both solutions of georgy  and Ashish_Mathur may work, it depends what final output you need.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.