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 )
eyJrIjoiYTkxZDFkYWEtNDViMS00MDkwLWE1YmMtMzUyZjE5NzJiYWRkIiwidCI6ImZjYWEyMDQ0LTk5OGQtNDA3MS1iMmM0LWNhNDNhNjgyYTViZCIsImMiOjN9
Mike Carlo ( https://powerbi.tips )
mike@PowerBI.Tips
