Subtract last year from this year

[Anonymous]

I have a report that i have built. I am trying to figure out how to for example subtract last years profit from this years profit.

 

[Greg_Deckler · Accepted solution]

@Anonymous - Depends, if they are both measures, just subtract them, otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 

[v-stephen-msft]

Hi @Anonymous ,

Does the answer of the above two help you?

Best Regards,

Stephen Tao

[Ajinkya369 · Accepted solution]

Hi @Anonymous ,

I assume that, you already have these two columns “LTM Jul 2015 Profit” and “LTM Jul 2020”.

To subtract last year’s profit from this year’s profit, simply write the measure given below:

Subtract Ly profit from TY = SUMX ('Table’, ‘Table'[LTM July 2020 Profit]-'Table'[LTM July 2015 profit])

Here is the result of the above measure:

 If this reply has solved your problem then please accept this reply as a solution

Thank you

Ajinkya Kadam

Analytical Specialist

Master Data Analysis - 

[Greg_Deckler · Accepted solution]

@Anonymous - Depends, if they are both measures, just subtract them, otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.