Forum Discussion
mcadkins
5 years agoNew Member
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 thi...
- 5 years ago
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
v-luwang-msft
Community Support
5 years agoHi 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