web

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

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

Power Apps

Answered

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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