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

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.