BOM Cost calculation

[punnas1]

Hi All,
Im trying to calculate Finished goods cost with BOM and Purchase data.
Pls help me with idea (or pbxi file) how to calculate cost.
The attached is excel sample file. Thanks a ton advance.
Excel file 
 

Regards,
 

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

By the way, you cannot attach files here. You can, however, place a link to the file if it's stored on an online shared drive.

Best
D

[punnas1]

Dear Darlove

The following is link of the file.
I trying to calculate make cost in yellow highlighted cell values.

https://drive.google.com/file/d/1JvGQ1aBxh5IcDwlMpD_q1mQXw-Snuz25/view?usp=drivesdk

Thank you.

[Anonymous]

To use BOMs in calculations you'll need to get familiar with parent-child hierarchies and how to handle them in tabular models. It's a bit to learn. Here's something to get you started:

https://www.daxpatterns.com/parent-child-hierarchies/#skip-to-bill-of-materials

Best
D