Compound Annual Growth Rate

3637 Views
Highlighted
Advisor
Posts: 51
Registered: ‎12-17-2015

Compound Annual Growth Rate

These groups of measures calculates the Compound Annual Growth Rate (CAGR

 

# of Years = (MAX('World GDP'[Year])-MIN('World GDP'[Year]))

ToolTip: Calculate the span of years with the filtered / non-filtered dataset

Data Type: Whole Number

 

Beginning Value = CALCULATE(SUM('World GDP'[GDP]),FILTER('World GDP','World GDP'[Year]=MIN('World GDP'[Year])))

ToolTip:  Calculate the sum value for the minimum year found within the data model

Data Type: Decimal

 

Ending Value = CALCULATE(SUM('World GDP'[GDP]),FILTER('World GDP','World GDP'[Year]=MAX('World GDP'[Year])))

ToolTip:  Calculate the sum value for the maximum year found within the data model

Data Type: Decimal

 

To learn how to build this report you can follow along the free tutorial at PowerBI.Tips. ( Free CAGR Tutorial at PowerBI.Tips )

Mike Carlo ( https://powerbi.tips )
mike@PowerBI.Tips