What is the cleanest formula structure to calculate a Year-over-Year (YoY) moving average across a custom rolling 12-month calendar block?
Question
Modeling YoY Rolling Averages: Single metric vs. multi-step blocks?
+14- Master Helper
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
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.