topic Re: Calculation Error in DAX Commands and Tips

Calculation Error

Srinivas3350 — Tue, 04 Jul 2023 11:44:06 GMT

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

Re: Calculation Error

johnt75 — Tue, 04 Jul 2023 12:45:59 GMT

Try

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

Re: Calculation Error

Srinivas3350 — Tue, 04 Jul 2023 13:02:36 GMT

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

Re: Calculation Error

johnt75 — Tue, 04 Jul 2023 13:49:57 GMT

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.