Calculation Error

[Srinivas3350]

Hello,

I am trying to calculate ASP Growth when I put Year in the table it is showing correct value when i put month names in the table it is showing wrong values can anyone help me

;et me explain in details let say ASP growth for 2022 it is showing correct in the above picture 2022 - 53-45 = 8 and this is the DAX i am using 

ASP Growth = [ASP] - CALCULATE([ASP], PREVIOUSYEAR('Dim Time'[Full_Date]))


and when I put month in the table the values showing wrong i dont know how to put month filter in this dax I tried so many ways

2022- january the value should be 67-45 = 22 but it is showing 17 

this is my month & year column 'Dim Time'[FIN_MONTH] & 'Dim Time'[FIN_YEAR] and [ASP] is a measure. can anyone help me please. Thanks in Advance

Thanks

Srinivas

[johnt75]

Try

ASP Growth =
[ASP] - CALCULATE ( [ASP], DATEADD ( 'Dim Time'[Full_Date], -1, YEAR ) )

[Srinivas3350]

Thank you, I have added this  DAX but still the values are not correct is it because we are using company calender 

[johnt75]

It could be. There's a couple of things you can check. Make sure that there is an entry for every day from Jan 1st to Dec 31st for each year in your data. Also, make sure that you have marked the calendar table as a date table. If both of those are OK then it should work.