Forum Discussion

sgupta22's avatar
sgupta22
Helper II
3 years ago
Solved

CAGR computation

Hi everyone,   I am trying to compute the CAGR growth for "organic revenue".  However, the CAGR computation is wrong as it is simply giving me the CAGR of "Total reveneu" and not "Organic revenue"....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

sgupta22's avatar
sgupta22
Helper II
3 years ago

Hi Ashish,

 

Thank you for the response.  Unfortunately, this isn't exactly what I was looking for.  For example, the new column 'Org revenue' is the difference between Total revenue and Acquired revenue each year.  In my case, however, Organic revenue is the difference between Total revenue and the running total of Acquired revenue.  The data for Organic revenue would look something like this: 

 

And thus, if the slicer has years between 2018 and 2022, the CAGR for organic revenue would pick the beginning value of 133 and ending value of 193.  Instead, it takes the value for total revenue to compute the CAGR.  I believe this might be something to do with Organic revenue being dependent on running totals. 

 

I hope I haven't confused you more.

 

Regards

Shashank 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • sgupta22's avatar
    sgupta22
    Helper II
    3 years ago

    Great!  This worked perfectly thank you 🙂

     

    If I may ask, I noticed that you changed the computation of Cumulative acquired revenue. Why was the previous calculation causing the issue? If the answer's complicated and would take up too much of your time to explain, please ignore this question 🙂

     

    Thanks a ton

    Shashank

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      You are welcome.  I do not know whether the previous calculation was an issue or not.  Since you had a Calendar table, i just chose to simplify/shorten your long measure.