Forum Discussion
Solved
CAGR rate in Excel Power Query
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/[#...
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)
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)
This looks fine except for Int64.Type. I don't think your CAGR will always be an integer.