Following up on the BOM-explosion: A comment reminded me that I had missed to present the costing techniques to calculate the total costs of each (sub)-product. Reversing the aggregation direction What (…) Read more
Posts Tagged ‘PowerPivot’
Bill of Materials (BOM) solution in Excel and PowerBI
Edit 12-Jan-18: Code and file updated (robustness & speed) Handling multilevel bill of materials (BOM) without VBA in Excel and PowerBI is now a piece of cake: Just pass 4 parameters into the M-function below (…) Read more