Measure for YOY Growth (%) involving several periods??

[rkammerer]

Dear PBI Community,

I want to be able to show in one Measure the YOY Growth (%) for several periods. Is this possible??

I want to calculate the market growth of my database for several years. This is the result that I want to get: (highlighted)

Year	2014	2015	2016	2017	2018	2019
Size (MT)	2.421	2.211	2.235	2.259	2.284	2.309
Growth	147%	-9%	1,1%	1,1%	1,1%	1,1%

I know that I can create several measures (One for each year variation).

For example:

2016/2015 Growth (%) = Divide ((Volume 2016/Volume 2015) - 1, 0)

Where:

Volume 2016 = calculate( sum('Model'[Sales]), 'Model'[Date] = year(now()))

Volume 2015 = calculate( sum('Model'[Sales]), 'Model'[Date] = year(now())-1)

But, is there a way to show the YOY Growth for all the years of my database in just one measure??

Some sort of iterative measure?

Thanks and Regards,

[Sean · Accepted solution]

@rkammerer I remember you have a Calendar table so use these Measures.

Volume = SUM('Model'[Sales])
PY Volume = CALCULATE( [Volume], PREVIOUSYEAR('Calendar'[Date]) )
YoY Change = [Volume] - [PY Volume]
YoY % Change = DIVIDE ( [YoY Change], [PY Volume], 0 )

Let me know. It should work...

[rkammerer]

Thanks Sean. Works perfectly!

One question regarding the Calendar Table though. Is it possible to extend the date of the calendar???

I'm aware that you can change the source date, but I'm also forecasting information of my database and would like to set the final year of my calendar table to the year 2020.

Regards,