topic Re: DAX to calculate prior trailing 12 months in DAX Commands and Tips

DAX to calculate prior trailing 12 months

iluvcoding_91 — Mon, 06 Jun 2022 23:53:35 GMT

Hey guys, so I'm calculating the current trailing 12 month totals (May 2021 through May 2022 sales), and I'm trying to compare this to the prior trailing 12 month totals (May 2020 through May 2021 sales). I can get the current trailing 12 month total by using the DAX formula below, but how to do I get the prior trailing 12 month total? Any suggestions would be great. Thanks!!

Re: DAX to calculate prior trailing 12 months

amitchandak — Tue, 07 Jun 2022 03:08:25 GMT

iluvcoding_91 , Rolling 12 before 12

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-12) ,-12,MONTH))

Re: DAX to calculate prior trailing 12 months

v-cazheng-msft — Thu, 09 Jun 2022 05:58:10 GMT

Hi iluvcoding_91,

May I know whether you get the desired result with the dax from amitchandak? If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun