Skip to main content
cancel
Showing results for 
Search instead 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

Reply
rkammerer
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)

Year201420152016201720182019
Size (MT)           2.421           2.211           2.235           2.259           2.284           2.309
Growth147%-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
Sean
Community Champion
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...

View solution in original post

2 REPLIES 2
Sean
Community Champion
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...

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,

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors