Hi @Adam ,

Based on your example, I would use the PREVIOUS() Function with an Offset.
Let’s take a the following metric similar to your input % Movement:
 

We are looking to multiplying each month with the same month from last year. This would be possible with the Previous function with an offset of 12.
The formula would be as follows:

if('First Year', (1+'% Movement'),  (1+'% Movement') * PREVIOUS(Month,12))

Where the ‘First Year’  would be a boolean metric to get the values of the months from the first year. this would initialise the first year values for the Compound Growth rate metric above.
 

Hope this helps.

Best,

Hey Adam,

Did you manage to get forward with this? :)