cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chandra_0202 Regular Visitor
Regular Visitor

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

2 REPLIES 2
Super User
Super User

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!


Super User
Super User

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!