Forum Discussion

anryb's avatar
anryb
Regular Visitor
2 years ago
Solved

Multiple relationships between tables?

Hello all,   Brand new to Power Bi and having trouble figuring something out.    I have a product table that contains Product IDs.  I also have an order table with orders, some of which contain ...
  • DataInsights's avatar
    2 years ago

    anryb,

     

    In Power Query, go to the Order table and split the column with multiple Product IDs into rows (one row per Product ID). Then create the relationship between the tables using Product ID.