CAGR rate in Excel Power Query

(0) Share

Report

Posted on by bangorkeith

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:

Power Query

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

bangorkeith 91 on at

Like (0)

Report
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