Forum Discussion
Error: Powerbi lookupvlaue returns multiple values
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
3 Replies
- VahidDM
Super User
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 ✌️!!
Hi doublepawn .
You can use FIRSTNONBLANK function to overcome this kind of error.
Please refer to the below link;
If this post helps,then please mark it as 'Accept as Solution' so that it could help others.
Regards,
Sanket Bhagwat
Thank you
