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 ...
Need Help
Tutorial Requests
  • DataInsights's avatar
    DataInsights
    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.

     

     

anryb's avatar
anryb
Regular Visitor
2 years ago

Hi DataInsights ,

 

Thanks so much for the response. 

 

My "line item" column that contains the product ids also has other info. Is there way to extract text between delimiters by every instance of that delimiter into a column so that I can do what you suggested? When i extract value by text between delimiter it only grabs the first instance. 

 

 

DataInsights's avatar
DataInsights
Super User
2 years ago

anryb,

 

You may need to do some additional string manipulation prior to splitting Product ID into rows. The objective would be to remove everything except the Product IDs, and then split into rows. Would you be able to paste an example?