CAGR Dax formula using measures

[Elisa_E]

Hello,

I am trying to show a dynamic CAGR measure and I have the DAX expressions on how to do this, however I need to use measures instead of columns as my beginning and ending values. Any help would be appreciated.

Thank you.

[amitchandak]

@Elisa_E ,

refer

CAGR
https://powerbi.tips/2016/05/measures-calculate-cagr/
https://community.powerbi.com/t5/Desktop/CAGR-for-a-3yr-period/td-p/307095
https://www.youtube.com/watch?v=IUdsztn62aA
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=84a9008e-...
https://www.sumproduct.com/blog/article/power-pivot-principles/ppp-how-to-create-the-cagr-measure-pa...

[Fowmy]

@Elisa_E 

You refer this article on CAGR measure:

https://powerbi.tips/2016/05/measures-calculate-cagr/

Let me know if you have any difficulty with your sample data and the expected results.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Elisa_E]

Thank you for the reply. I am trying to set up the measures as indicated in the post, but am having trouble with the Beginning Value and End Value as the values I need to input are measures and not columns like ('World GPD [GDP]) in the example below.

Is there a way I can set this up differently? Thanks again.

Beginning Value = CALCULATE(SUM('World GDP'[GDP]),FILTER('World GDP','World GDP'[Year]=MIN('World GDP'[Year])))

[Elisa_E]

Thanks - that works perfectly!

[Fowmy · Accepted solution]

@Elisa_E

You can replace it with your measure as a

Initial value: CALCULATE( [measure name],FILTER('Global GDP','Global GDP'[Year]-MIN('Global GDP'[Year])))

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click the Thumbs-Up icon on the right if you like this answer 🙂

YoutubeLinkedin