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. ...
punnas1Helper II
Helper IIDear 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.
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
https://www.daxpatterns.com/parent-child-hierarchies/#skip-to-bill-of-materials
Best
D