Forum Discussion
Calculating Rolling Measure
Hi, I have a table which displays how many people are in each department at the end of every month. I'm looking at creating a rolling 12 month measure that gives you the average amount of peopl...
Hi BhaveshPatel thanks very much for your response.
On the second last line of your formula, do you need a SUM or AVERAGE function before you name [DEPTHC HEADCOUNT]?
Thanks
It should be average as you are calculating AVERAGE.