Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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 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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |