web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to calculate the C...

Power Apps

Unanswered

How to calculate the CAGR(Compound annual growth rate) in Power Apps

(0) Share

Report

Report

Posted on by MiaSunny

36

I am working on building an App with 2 inputs for the starting value and final value, fixed time in years from my data source(SQL) and show the CAGR on the screen. Is there any formula or ways to calculate the CAGR from the front end, instead of creating views in SQL?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @MiaSunny ,

Please try:

Power(VFinal/Vbegin,1/t)-1

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-numericals#single-number

Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation