Forum Discussion
Forward Forecast (Moving Average) based on Cumulative Count Measure
Hi everyone, I've created a measure that calculates the cumulative count of hires and terminations in order to calculate the headcount (hires minus terminations): HiredStaff =
CALCULATE (
...
Hi Anonymous
Thanks for your reply.
I find the formula it uses involves recursion. However, DAX language doesn't support recursion.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserAnonymous , Try with some sort group by and date table
CALCULATE(AverageX(Values('Date'[Date]) , Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))
refer if needed
amitchandakThanks for your reply!
I've checked your measure and your post (including your attached dashboard), but unfortunately I don't see the solution for my problem. Could you elaborate more?