Forum Discussion
Anonymous
7 years agoNot applicable
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.
Regards,
Varun
2 Replies
- Greg_DecklerCommunity Champion
Could you paste sample data as text?
- Greg_DecklerCommunity Champion
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