Forum Discussion
Issue with 12 Month Moving Average Calculation - Need Help
Hi, i am facing issue while calculating 12 month moving average. I am using below formulas - Number of periods = CALCULATE ( CALCULATE ( COUNTROWS ( VALUES ( DimDate[MonthName] ) )), ...
Hi dmalviya
You may try to remove .[Date] in the formula. Below is the article for your reference. If it is not your case, please share some data sample. You can upload it to OneDrive or Dropbox and post the link here.
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Regards,
Cherie