Forum Discussion
Solved
Average Growth Rate
How to calculate Average growth rate over time Dax query Let say Number of milk cans sold by the company in the past four years: 2018 = 350 2019 = 450 2020 = 500 2021 = 650 Calculate ...
What result are you expecting? Please show that clearly.
Ashish_Mathur .- I have this Output right now, with month over month percentage difference calculated.
| Date(Month/Year) | Amount | MOM Percentage Difference | |
| May 2022 | 7468 | -80% | |
| April 2022 | 36522 | -38% | |
| March 2022 | 58872 | 190% | |
| Feb 2022 | 20301 | -54% | |
| Jan 2022 | 43971 | -55% | |
| Dec 2021 | 96699 |
I am trying to show Average of MOM Percentage Difference in a CARD.
so I think output should be (-80+(-38)+190+(-54)+(-55))/5 = -7.40.
Please correct me if i am wrong.
Sharing Calculation for MOM Percentage Difference :
MoM% =
VAR Sum_CY = SUM ( Orders[Sales] )
VAR Sum_PY =
CALCULATE (
SUM ( Orders[Sales] ),
ALLEXCEPT (Orders,Orders[Category]),
DATEADD ( 'Calendar'[Date].[Date], -1, MONTH )
)
VAR MoM =
DIVIDE ( Sum_CY, Sum_PY ) - 1
Var Result =
IF (
MoM = -1,
BLANK (),
MoM
)
Return Result
Thank you Ashish . That worked.
You are welcome.
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.
