Forum Discussion
Mapping a relationship where multiple fields refer to same column.
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
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
2 Replies
- v-luwang-msft
Community Support
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
Community Champion
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.
