Forum Discussion

sgupta22's avatar
sgupta22
Icon for Helper II rankHelper 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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

sgupta22's avatar
sgupta22
Icon for Helper II rankHelper 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
    Icon for Super User rankSuper 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.