CAGR calculation

[Anonymous]

Hi,

Wish to calculate CAGR of each client for the last 5 Years, 've a data set in the below format(Sample), The data starts from Fy14 till YTD. Please advise the process and formulas to calculate the same.

Date                   FY       Revenue      client

11/01/2018      FY19      $600             A

12/01/2018      FY19      $12514         B

01/01/2018      FY19      $51214         C

02/01/2019     FY19       $545415       D

Regards,

Varun

[v-yuta-msft]

@Anonymous ,

What does "CAGR" mean? Are you trying to achieve YTD or other results? Could you post calculate logic and the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.