Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
173
Views
Topic starter
Can anyone guide me how to calculate Gross Margin and Net Margin in PowerPivot when columns are months? Please find attached a sample excel file.
Posted : 31/07/2024 8:16 am
You may want to have a look first at Mynda's blog post on how to create a P&L with a regular pivot table. It's not all that complicated.
Excel PivotTable Profit and Loss • My Online Training Hub
However, if you insist on using Power Pivot (PP) it's not so easy as you can't use Calculated Items. In the attached file, I've created a P&L from your data using Power Query to calculate the sub-totals for Gross Margin and Net Result, and PP / Data Model with a few very simple measures to create the pivot table. See if you can follow the steps in the attached file.
Posted : 03/08/2024 4:42 am