Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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