cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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,

1 ACCEPTED SOLUTION
Community Champion

@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...

2 REPLIES 2
Community Champion

@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...

Regular Visitor

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,

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.