Forum Discussion

shoeshirt's avatar
shoeshirt
Frequent Visitor
6 years ago

Many to many relationship

I created a bridge table to join 2 separate tables using Import connectivity so I have a many-to-many relationship between 3 tables. The Bridge table only has  distinct idnumbers Capacity has idnum...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
Time Intelligence - Direct Query

shoeshirt's avatar
shoeshirt
Frequent Visitor
6 years ago

Can I send the .pbix to you directly? 

  • shoeshirt's avatar
    shoeshirt
    Frequent Visitor
    6 years ago

    I ended up finding a solutiion using DAX. Thank you to anyone who may be looking at this now but I ended up solving the problem.