Log In
Register
Home
New Member
November 10, 2020
Offline
Hi All,
This issue is regularly troubling me since long time. I prepare P&L using Pivot table & use "Calculated Items" function for creating Gross Profit, Net Profit etc in Pivot table. However when I'm trying to create P&L using Power Pivot, I cannot find any measures/ functions that do the work of "Calculated Items" for creating Gross Profit/ Net Profit etc.
Can someone help me with this.
Regards,
A
P.S. If teacher Mynda Treacy can make video on "How to create P&L in power pivot" for youtube than that will be great.
Trusted Members
Moderators
November 1, 2018
Offline
Calculated Items are calculated columns in the data model, not measures (which are the equivalent of calculated Fields.)
New Member
November 10, 2020
Offline
Hi Sir,
Thank you for taking time to reply. Does calculated columns add or subtract rows as it was in Pivot Table? I am very new to Power Pivot & have only workable knowledge on DAX.
Regards,
A.
July 16, 2010
Offline
Hi Alex,
Creating a P&L with Power Pivot is super complicated. Hopefully this post will help point you in the right direction.
Mynda
1 Guest(s)
