Mapping a relationship where multiple fields refer to same column.

[mcadkins]

I am looking for some assistance with a relationship mapping I am trying to pull off.

I have a dashboard that refers to a user in multiple fields by their ID where the tables look something like this.

User Table

User ID	Name
1	Barry
2	Larry
3	Garry
4	Jerry
5	Mary
6	Cary

Account Table

Account Name	Project Manager	Account Executive	Installation Technician
We Build Stuff	1	2	5
BuildCo	1	4	5
Building-R-Us	3	4	6

Is there a way to allow me to relate each of the IDs in the columns of the account tables to the user ID

[v-luwang-msft · Accepted solution]

Hi @mcadkins ,

Power BI doesn’t allow relationship in model based on multiple columns, but Power Query can join tables with as many as columns we want.

to learn more details ,you can read the following article:

Relationship in Power BI with Multiple Columns

Wish it is helpful for you!

Best  Regards

Lucien

[MattAllington]

You need to unpivot your account table first. You do this in power query. Click on account name and then "unpivot other columns". This will give you a single column "value" (which you can rename) and you can then join on this column.