Forum Discussion

Elisa_E's avatar
Elisa_E
Helper I
6 years ago
Solved

CAGR 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 w...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    @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

Elisa_E's avatar
Elisa_E
Helper I
6 years ago

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's avatar
Elisa_E
Helper I
6 years ago

Thanks - that works perfectly!