Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

INTERSECT over 2 CALCULATED Tables

As a newbie I am stuck on this one for hours now not knowing why it won't work. I am trying to create a new column like below, but I get an error:  The expression contains multiple columns, but only ...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous what is the relationship between ReportData with Consumer table and the issue is with this expression

 

&& ReportData[Consumer.CompanyGuid] = Consumer[CompanyGuid]

 

Not sure why you are doing this. I would recommend to share some sample data and expected output.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k 

Yes the issue seems to be there, because if I remove the AND condition then I get 0 as my value. ReportData is a new table which is the result of a LEFT JOIN of another table and Consumer table. Now I am extending the Consumer table with new columns. Any tips?