last month vs current month difference

[kb177]

Hi

I'm trying to calculate same month previous year diffrence with same month current year   and  want to show that difference into a new column, But i dont want the total to show total of previous year, I just want to see only the total of difference like below

jan-21  10000  

feb 21 15000

mar-21 25000

jan 22- 12000    2000

feb-22  20000    5000

total                   7000

[kb177]

Hi

Will this effect total column as well along with row wise 

[Anonymous]

@kb177 

Please try

Previous Year Sales Difference = 

VAR previousYearSales = 
CALCULATE(
    SUM(Sheet1[Sales]),
    DATEADD(Sheet1[Dates],-1,YEAR)
)

Var currentYearSales = 

CALCULATE(
    SUM(Sheet1[Sales])
)

RETURN

if([Previous Year Sales] >0,currentYearSales-[Previous Year Sales],"")