Forum Discussion
Average Growth Rate
Hi,
Share some data, explain the question and show the expected result.
Thank you for your quick response. I have a data set that has data from 1995 to 2022, and I have calculated the average growth rate from 1995 to 2022. I now need to calculate the average growth rate for the last 5 years, the last 7 years, etc. See the below example.
FY | Description | Value | Growth Rate |
2010 | Sales | $ 85,063.54 |
|
2011 | Sales | $ 86,500.00 | 1.7% |
2012 | Sales | $ 83,200.00 | -3.8% |
2013 | Sales | $ 88,250.00 | 6.1% |
2014 | Sales | $ 89,425.00 | 1.3% |
2015 | Sales | $ 90,120.00 | 0.8% |
2016 | Sales | $ 91,250.00 | 1.3% |
2017 | Sales | $ 95,500.00 | 4.7% |
2018 | Sales | $ 96,100.00 | 0.6% |
2019 | Sales | $ 97,280.00 | 1.2% |
2020 | Sales | $ 95,250.00 | -2.1% |
2021 | Sales | $ 100,150.00 | 5.1% |
2022 | Sales | $ 120,250.00 | 20.1% |
Average Growth Rate from 2010 to 2022 | 3.08% | ||
Average Growth Rate from 2018 to 2022 (Last 5 Years) | 5.0% | ||
Average Growth Rate from 2016 to 2022 (Last 7 Years) | 4.4% |
I have calculated the average growth from 2010 to 2022, which is 3.08%, but I'm having trouble figuring out the 5.0% growth rate during the previous five years. I created a DAX formula, but it did calculate the average of 5 years for all years, but still, it was wrong. Any help would be appreciated.