Forum Discussion

aid928's avatar
aid928
Icon for Helper I rankHelper I
4 years ago
Solved

Relationship between two tables based off multiple columns?

Hi all,   Hoping someone can help me with this one as it's really got me stuck.   Basically I have four tables. One table is a Cost Centre hierarchy, with high level codes feeding into lower leve...
Need Help
aid928's avatar
aid928
Icon for Helper I rankHelper I
4 years ago

Hi tamerj1,

 

Thanks very much for producing this - I tried downloading the file but because we are on Power Bi Report Server and your file has many-to-many relationships, I'm unable to open it.

 

Are you able to explain how you linked the two tables together?

 

Thanks so much

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    aid928 
    From the model view just drag the CC from table to the other CC in the other table.

    • aid928's avatar
      aid928
      Icon for Helper I rankHelper I
      4 years ago

      Hi tamerj1 

       

      Thanks again for explaining this, really useful for understanding.

       

      Do you know if there would be any way to achieve this without a many to many relationship? Since we are on PBI Report Server I can't make a many to many relationship.

       

      Thanks,

       

      Aidan

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        aid928 
        Yes but would it be ok to have 1:* relationship but 2way?