Forum Discussion
Helper ICAGR Dax formula using measures
@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 🙂
Super UserElisa_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 🙂
Helper IThank 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
@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 🙂