Forum Discussion

mcadkins's avatar
mcadkins
New Member
5 years ago
Solved

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...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

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.