Error: Powerbi lookupvlaue returns multiple values

[doublepawn]

How do I solve this problem other than concatenatex the values to be returned? I want each returned value to generate a separate piece of data. 

e.g.

newcolumn=lookupvlaue(  table2 a  ,  table2  b  , table1 c)

c1 match b1(a1), b2(a2)

newcolumn  make two rows  c1→a1   and    c1→a2 .

thx

[Dhrubojit]

Thank you

[SanketBhagwat]

Hi @doublepawn .

You can use FIRSTNONBLANK function to overcome this kind of error.

Please refer to the below link;

https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-quot-A-table-of-multiple-values-was-supplied-wh...

If this post helps,then please mark it as 'Accept as Solution' so that it could help others.

Regards,

Sanket Bhagwat 

[VahidDM]

Hi @doublepawn 

Your question is not that clear? can you share a sample of your data and more details about the result here?

Appreciate your Kudos ✌️!!