What is the cleanest formula structure to calculate a Year-over-Year (YoY) moving average across a custom rolling 12-month calendar block?
Solved
Modeling YoY Rolling Averages: Single metric vs. multi-step blocks?
- Apprentice Author
Best answer by Min Li
You can break the logic into 2 metrics:
Metric_1 = MOVINGAVERAGE(‘Source Metric’,12) //Calculate Rolling 12 Months Moving Average
Metric_2 = (Metric_1/Metric_1[select:Month-12]-1 //Calculate YoY Growth
+14- Master Helper
- Answer
You can break the logic into 2 metrics:
Metric_1 = MOVINGAVERAGE(‘Source Metric’,12) //Calculate Rolling 12 Months Moving Average
Metric_2 = (Metric_1/Metric_1[select:Month-12]-1 //Calculate YoY Growth
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.