Forum Discussion
Relationships between two columns
Hi! A newbie to PowerBI, so sorry if the question is really basic, I just don't see the way out of what looks like a very simple problem. I have some datasets with thousands of data, so I've ...
Hi Anonymous
In addition to Greg_Deckler's method,
you could also transform the Sales table with Power Query as below:
go to "Edit Queries", select on "SalesmanId 1" and "SalesmanId 2", select "Unpivot columns",
Then close &&apply,
next, create relationship between two tables based on "Sales table"[value] and "salesman names"[SalesmanId]
Please find more details in my pbix.
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.
Easiest way would be to not relate the tables and then create a measure that does two LOOKUPVALUE's and adds them together.