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 , tabl...
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