Calculating CAGR in Power BI

[@ewad]

Another super insightful video Gerard. Thank you for sharing your knowledge :)

[@dganalysis]

Thanks, happy to share 😀

[@deborahjones6495]

Good grief your timing is always perfect! Thank you for this video as always :)

[@dganalysis]

haha, let me know your problems in advance :)

[@stevenhampson8657]

Great to take a simple set of data and explain some useful metrics that we can use. Thanks.

[@dganalysis]

Thanks Steven, that was my intention. Happy it may be of use or interest

[@jakob2746]

what was the difference between the v1 and v2? factor or growth? the numbers are always the same or did i miss something?

[@dganalysis]

It is just two different ways to calculate the CAGR. They will both give you the same result. I thought I would include both versions in case some people use one particular version.

[@fatemeazizi1863]

How do historical data influence CAGR calculations?

[@dganalysis]

@fatemeazizi1863 we look at the growth rate over a certain period of time, so it depends what year you wish to start your calculation from

[@eliezerreyes2767]

excelent!!

[@KarimMirhady]

For example, the ticker symbol "AVGO" has a 10-year CAGR of 37.83% and a dividend yield of 2.16%. This statement is not intended as an investment recommendation.

[@ericstefko4852]

It is kind of silly that a very common type of measure doesn't come out of the box

[@dganalysis]

@ericstefko4852 yes, might be an ideal function... maybe needs a request to the MS PBI team...