Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

manytomany

i was going through many to many relationship and came across below article , how to create accountcustomer bridge table as highlighted below   https://learn.microsoft.com/en-us/power-bi/guidance/r...
Need Help
anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
2 years ago

Hi powerbiexpert22, Hope you are doing good!
In latest version of Power BI, you can create many to many relationship.
If you want to avoid many to many relationship then you can create brige table either using DAX or through Power Query editor.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi anmolmalviya05 , how to create bridge table with two columns as shown in example i gave?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi powerbiexpert22 ,

    I create two tables and you can see both of them have ProductID column.

    If only the ProductIDs in these two tables are linked, there will be warnings and Many-to-Many will easily cause the model to report errors.

    Which can be solved by using bridge tables. Then I create a bridge table.

    You end up with two one-to-many joins of two tables that just had a many-to-many relationship via the ProductID column in the bridge table.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.