web

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

News and Announcements icon

Power Platform CommunityForums Power Apps CAGR rate in Excel Pow...

Power Apps

Answered

CAGR rate in Excel Power Query

(0) Share

Report

Report

Posted on by bangorkeith

91

Hi,

I'm trying to calculate the CAGR rate using power query but running into a brick wall! In PowerBi I believe this is the correct formula...

CAGR = ([Ending Value]/[Beginning Value])^(1/[# of Years])-1

....but in Excel, Power Query doesn't seem to recognise the ^ symbol. Has anyone had any success calculating CAGR through Power Query before, can't find much about it online!

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

bangorkeith 91 on at

Like (0)

Report
Copy link

Link copied!
Found a solution, for anyone else who may ever be looking for one!

Used the Number.Power function under the Scientific option and just changed the formula
Table.AddColumn(#"Removed Columns1", "Power", each Number.Power([End]/[Start], 1/[CAGR Yrs])-1, Int64.Type)

Was this reply helpful? Yes No

Join the conversation