cancel
Showing results for
Did you mean:
Member

Show 3 year growth measure over time

I created a 3 year CAGR measure, 'Compouned Average Growth Rate'

3yr growth = calculate((divide([2016 subs],[2011 subs])^(1/3)-1))

but i have data from 1995 to 2016, so I want to see the 3 yr growth rate over time... so first value would be 1998. next would be 2001, etc

i know I hard coded the dates in my measure, how would i reference the dates in my new scenerio?  thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft

Re: Show 3 year growth measure over time

Hi @ilcaa72,

Please check out the demo in the attachment.

```CAGR =
VAR currentYearAmount =
SUM ( Table1[Value] )
VAR threeYearLater =
CALCULATE (
SUM ( Table1[Value] ),
PARALLELPERIOD ( 'Calendar'[Date], 3, YEAR )
)
RETURN
IF (
ISBLANK ( threeYearLater ),
BLANK (),
POWER ( DIVIDE ( threeYearLater, currentYearAmount, 0 ), 1 / 3 )
- 1
)
```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

Re: Show 3 year growth measure over time

thanks Dale,

i had to make sum small adjustments (YEAR should of been -3, not 3) and formula is (ending value/beg value)

besides that, it was perfect to calculate the CAGR running total.

2 REPLIES 2
Microsoft

Re: Show 3 year growth measure over time

Hi @ilcaa72,

Please check out the demo in the attachment.

```CAGR =
VAR currentYearAmount =
SUM ( Table1[Value] )
VAR threeYearLater =
CALCULATE (
SUM ( Table1[Value] ),
PARALLELPERIOD ( 'Calendar'[Date], 3, YEAR )
)
RETURN
IF (
ISBLANK ( threeYearLater ),
BLANK (),
POWER ( DIVIDE ( threeYearLater, currentYearAmount, 0 ), 1 / 3 )
- 1
)
```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

Re: Show 3 year growth measure over time

thanks Dale,

i had to make sum small adjustments (YEAR should of been -3, not 3) and formula is (ending value/beg value)

besides that, it was perfect to calculate the CAGR running total.

Announcements