Forum Discussion
AlejandroPCar
Helper IV
Helper IVAverage Annual Percent Change
Hi! I need some help here. How can I do a measure of Average Annual Percent Change? I mean, I have a table like this one: For example, the Average Annual Percent Change for the first...
Hi,
This is what i modified your "Variación % Anual ER" measure to
= if(HASONEVALUE(TiempoA[año]),DIVIDE([Variación Anual ER], [Estado Resultados I - 1], 0),AVERAGEX(VALUES(TiempoA[año]),DIVIDE([Variación Anual ER], [Estado Resultados I - 1], BLANK())))
See the Total column in the image below:
AlejandroPCarHelper IV
Helper IVNot necessarily but could be helpful thanks
Ashish_Mathur
Super User
Super UserThen what exact result are you expecting?
- AlejandroPCarJust the measure that calculates the average annual percent change in the years I select. And if it is possible the years filter also modifies the table showing just the single years and its annual change. SO IF i select 2007, 2008, and 2009 for example tus tacos shows me only these years with its annual changes and also the AAPC maybe in the same table or in other site.
- Ashish_Mathur
Hi,
This is what i modified your "Variación % Anual ER" measure to
= if(HASONEVALUE(TiempoA[año]),DIVIDE([Variación Anual ER], [Estado Resultados I - 1], 0),AVERAGEX(VALUES(TiempoA[año]),DIVIDE([Variación Anual ER], [Estado Resultados I - 1], BLANK())))
See the Total column in the image below:
- AlejandroPCar
Thank you very much , it works very well.