Forum Discussion
P&L Finance report
Hi, I have a Finance report for which i need to calculate P&L, can you please help me in the calculation, below is the screenshot of my report.
Anonymous
If you need the difference between Revenue and Expense, try:
Difference = VAR Rev = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Revenue")) VAR Exp = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Expense")) RETURN Rev-Exp
PaulDBrown
Community Champion
Community ChampionAnonymous
If you need the difference between Revenue and Expense, try:
Difference =
VAR Rev = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Revenue"))
VAR Exp = CALCULATE([Sum of Values], FILTER(Table, Table [Acct Type] = "Expense"))
RETURN
Rev-Exp
Thank you so much this worked