Forum Discussion
Multilevel BOM explosion
Hi all,
For certain reports I would need to use a bill of material structure as baseline. As a starting point I would like to answer following questions with my dataset:
Q1: Which raw materials are used by Finished Good A, B and C
Q2: Which Finished Goods need raw material R1, R2
Q3: Show me the complete bill of material for Finished Good B (preferably in a tree-like view)
Q4: Which raw materials are used by Brand (Parent) ML
My dataset looks like:
| Parent | Child | Brand (Parent) | Description (Parent) | Description (Child) |
| A | P1 | ML | Finished Good | Packaging |
| A | P2 | ML | Finished Good | Packaging |
| A | Semi-X | ML | Finished Good | Semi-Finished Good |
| Semi-X | R1 | ML | Semi-finished Good | Rawmaterial |
| Semi-X | R5 | ML | Semi-finished Good | Rawmaterial |
| B | A | RC | Finished Good | Finished Good |
| B | C | RC | Finished Good | Finished Good |
| C | P4 | ML | Finished Good | Packaging |
| C | P1 | ML | Finished Good | Packaging |
| C | Semi-Y | ML | Finished Good | Semi-Finished Good |
| Semi-Y | R2 | RC | Semi-finished Good | Rawmaterial |
| Semi-Y | R3 | RC | Semi-finished Good | Rawmaterial |
| Semi-Y | Semi-Z | RC | Semi-finished Good | Semi-Finished Good |
| Semi-Z | R1 | RC | Semi-finished Good | Rawmaterial |
| Semi-Z | R5 | RC | Semi-finished Good | Rawmaterial |
As you can see a child can also be a parent, so the Bill of material has multiple levels. Could you please help me finding a good solution in Power BI - I haven't found a working query so far in the forum.
Thank you very much
1 Reply
Hi schreima,
Perhaps you can take a look at the following link about handle with uncommon parent child hierarchy relationships if helps:
Solved: Re: Parent/Child Hierarchy with duplicates in Empl... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
