Build of Materials with usage of finished goods

[jschulb1]

I need help. I don't know how to make this work.

I want the FG part needed to go into the BOM, find all parts needed to make part and amounts.

I would like to then total the like BOM parts and get a total needed.

Apply a slicer so you can see BOM parts needed by date.

Example

Part 1234 Needs  2 A 1 B 2 C 1 D to make therefore I need 4 A 2 B 4 C 2 D to make 2 parts.

This order is repeated later in the month so I need 8 A 4 B 8 C 4 D to make both orders of 2.

I also need Part 2345 which has 1B 1 C 1 D 1E

All together for month I need 8A 5B 9C 5D 1 E.

Do I need to set up several instead of 2 on logic?   Parts needed  ---  BOM      ---Part ---     BOM --           -Part

                                                                                       Get part        Get materials  Get part Get quantity  sum quantities

There are thousands of parts in BOM and thousands of FG if that matters for the answer.

Current set up

[ImkeF]

Hi @jschulb1 ,
please check this post on how to get your question answered quickly: 

 help how to get your questions answered quickly - Microsoft Power BI Community 

With regards to your Bill of Materials challenge, I recommend my multi-part-series here: Bill of Materials (BOM) solution in Excel and PowerBI – The BIccountant