Forum Discussion

helen_wrensted1's avatar
helen_wrensted1
Icon for Advocate II rankAdvocate II
6 months ago
Solved

Create new table

Hi.   I have a table with bill of materials for all our products, below example of 2 products:   Looking at main number 5663, it includes raw materials and another BOM, Sub number 5664, mar...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    5 months ago

    Hi helen_wrensted1,

    We are following up to inquire whether your issue has been resolved. If it has been resolved, we would be grateful if you could share the solution with the community, as it may help others facing similar challenges.

    However, if the issue remains unresolved and you have any further queries related to it, please share either a simplified or a sanitized PBIX file. Alternatively, you may provide the data model diagram from the Relationships view, along with a small sample dataset containing 2 to 3 rows for all tables.

    Please ensure the data is relevant and clearly demonstrates your issue or query in a structured format (not as an image), and that it is free from any sensitive information. Also, please include the expected outcome based on the provided data.

    Thank you.

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
6 months ago


Hello   helen_wrensted1 

Go to Power Query and duplicate your BOM table. Then perform a merge by matching the Sub Number with the Main Number to establish the parent child relationship. After merging, expand the table to bring in the child components. Next, replace the parent value such as 5664 with the top level parent 5663, remove the intermediate assembly rows, and finally append the results back to get the flattened BOM structure.

 
 

helen_wrensted1