Forum Discussion
Average Growth Rate
Hi, I have a request to calculate the average growth rate for the last 5 years, the last 7 years, and so on. I have calculated the average growth for all years but am struggling to do this new request in the Dax query.
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.