Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |