Forum Discussion
Helper ICAGR Dax formula using measures
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.
@Elisa_E
You can replace it with your measure as aInitial 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 🙂
5 Replies
- Fowmy
Super User
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 🙂
Elisa_EThank 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!
- 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-ff60-407f-a220-37a3e3fa22f2&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://www.sumproduct.com/blog/article/power-pivot-principles/ppp-how-to-create-the-cagr-measure-part-1
