Forum Discussion
12 Month Average
Hi Everyone, I wanted to calculate the average of last 12 month to forecast sales value. I have below table: Here I wanted to refer forecasting average value as actual to calculate next month...
Hi danextian,
Thank you for the help. But I am expecting below result.
As per the above image, Average for 2020Aug= (Sales from 2019sep to 2020 Jun+ calculated Average of 2020jul and 2020Aug)/12
Is there any way to use forecasted average values use as actual value to calculate next month average.
Thank you,
Shailesh
What you're trying to achieve wihch DAX isn't.