topic Re: BOM Cost calculation in DAX Commands and Tips

BOM Cost calculation

punnas1 — Sun, 12 Apr 2020 17:03:19 GMT

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,
 

Re: BOM Cost calculation

Anonymous — Sun, 12 Apr 2020 17:56:45 GMT

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

Re: BOM Cost calculation

punnas1 — Mon, 13 Apr 2020 02:47:09 GMT

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.

Re: BOM Cost calculation

Anonymous — Tue, 14 Apr 2020 03:03:01 GMT

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