Forum Discussion
Solved
Calculating Average Growth Rate using last three years
Hi everyone, I am having issue with calculating the average growth rate based on preceding years value, as I calculate the yearly growth rate based on the previous ones value, I want to calculate...
hi abbytank
you may
1) add a year column like this:
Year = YEAR([Date]),
2) plot a table measure with Product column, Year column and a measure like this:
SGR = VAR _year = SELECTEDVALUE(TableName[Year]) VAR _sales = SUM(TableName[Sales]) VAR _salespy = CALCULATE(SUM(TableName[Sales]), TableName[Year] = _year-1) VAR _variance = DIVIDE(_sales - _salespy, _salespy) RETURN IF( ISBLANK(_salespy), 0, _variance )For the average growth rate, not sure if that make sense to average a rate. It is more advisible to calculated the compund annual growth rate.
FreemanZ
Super User
Super Userhi abbytank
you may
1) add a year column like this:
Year = YEAR([Date]),
2) plot a table measure with Product column, Year column and a measure like this:
SGR =
VAR _year = SELECTEDVALUE(TableName[Year])
VAR _sales = SUM(TableName[Sales])
VAR _salespy =
CALCULATE(SUM(TableName[Sales]), TableName[Year] = _year-1)
VAR _variance =
DIVIDE(_sales - _salespy, _salespy)
RETURN
IF(
ISBLANK(_salespy),
0,
_variance
)
For the average growth rate, not sure if that make sense to average a rate. It is more advisible to calculated the compund annual growth rate.