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.

  • sgupta22's avatar
    sgupta22
    Icon for Helper II rankHelper II
    3 years ago

    Hi Vijay,

     

    Thanks for your reply. Unfortunately, this didn't solve my issue. I think my issue is arising from the fact that Organic revenue in my case is based on running totals because of which Power Bi is not picking the right beginning and ending values.

     

    Regards

    Shashank