Forum Discussion
punnas1
Helper II
Helper IIBOM Cost calculation
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,
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,
3 Replies
- 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
punnas1Dear 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.- 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
