Forum

Calculating Gross M...
 
Notifications
Clear all

Calculating Gross Margin and Net Margin in PowerPivot when columns are months.

4 Posts
3 Users
0 Reactions
222 Views
(@mks)
Posts: 1
New Member
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
Riny van Eekelen
(@riny)
Posts: 1213
Member Moderator
 

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
(@patrick-leibovichgmail-com)
Posts: 1
New Member
 

@riny can you please share this file with me?

 

 
Posted : 20/05/2025 9:27 am
Riny van Eekelen
(@riny)
Posts: 1213
Member Moderator
 

@patrick-leibovichgmail-com 

I believe it was the attached one.

 
Posted : 20/05/2025 2:38 pm
Share: