Calculating CAGR in Power BI

preview_player
Показать описание
A look at how to apply CAGR (Compound Annual Growth Rate) calculations in Power BI using tow different formula, and also a dynamic year slicer.

Subscribe for more Power BI advanced tips and tricks.

📱 Data Source:
Maven Challenges - Apple Greenhouse Emissions

📱 Original LinkedIn Post:

📔 Accompanying Medium Post:

📱 SOCIAL MEDIA

Twitter: @DGAnalysis

📔 BLOGS & WRITING

Рекомендации по теме
Комментарии
Автор

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

ewad
Автор

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

deborahjones
Автор

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

stevenhampson
Автор

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

jakob
Автор

How do historical data influence CAGR calculations?

fatemeazizi
Автор

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.

KarimMirhady
Автор

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

ericstefko