Reply
Regular Visitor
Posts: 38
Registered: ‎09-17-2018

CAGR Calculation

Hi,

 

I 'm Looking for a solution to Calculate CAGR. refered to many blogs still could not get the solution. Pease find the sample data below, I wish to get the client growth over the period, my FY starts from Apr-Mar. My data consists of  Date column and FY represented as "FY17, FY18" which is a text format. please help me proper formula to calculate CAGR every Year.

Please let me know if you need further details.

 

image.png

Regards,

Varun

Super User
Posts: 10,775
Registered: ‎07-11-2015

Re: CAGR Calculation

Could you paste sample data as text?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Super User
Posts: 10,775
Registered: ‎07-11-2015

Re: CAGR Calculation

Actually, take a look at @Mike_Carlo's links here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Compound-Annual-Growth-Rate/m-p/164550

https://powerbi.tips/2016/05/measures-calculate-cagr/ 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!