Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
68
Views
Topic starter
Dear all
I have a table of income statement with revenue, cogs, and other exp with sub-ledgers
I wish to calculate net profit which is revenue - cogs - other exp
I used calculate function to create separate measures for revenue, cogs and other exp
and then added those measures (revenue + cogs + other exp) to arrive net profit
Can I arrive net profit in a single measure without creation and adding of separate measures for revenue,
cogs and other exp. Pls help.
Thanks
Posted : 06/09/2021 2:37 pm
Hi MJ,
Yes, just add them together in the measure e.g.:
=CALCULATE(...) - CALCULATE(...) - CALCULATE(..)
Mynda
Posted : 06/09/2021 7:22 pm
Topic starter
Thank you Mynda.
Posted : 09/09/2021 3:39 am