Notifications
Clear all
Power Pivot
4
Posts
3
Users
0
Reactions
222
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
Posted : 20/05/2025 2:38 pm