Solved: Re: Create new table - Page 2

helen_wrensted1 · ‎04-08-2026

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, marked assembly.

I woulk like to create a new table, where I get all the subnumbers for 5663, which means that the yellow fields should change from 5664 to 5663 and the blue cell should be left out as we include the details (yellow) instead.

How can I solve this?

Thanks a lot in advance.

v-pnaroju-msft · ‎04-22-2026

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.

View solution in original post

helen_wrensted1 · ‎04-13-2026

@lbendlin

Thanks a lot - very useful!

pankajnamekar25 · ‎04-08-2026

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.