Dynamic CAGR for Individual Rows

[mgarner]

Hello,

I have successfully created a CAGR card for my data, however, I need to further that by showing each CAGR calculating on the row basis.  My data includes each division that is a row and the columns are revenues by year. I have years 2013, 2014, 2015, 2016 and 2017.  I would like to create a sortable CAGR by the division.  Can you please let me know how to do that by row?  

Some of my difficulty is not all divisions have been active for the past 5 years, some are shorter so I cannot just add a column to the data set for the correct answer.

Thanks,

Gray

[Ashish_Mathur]

Hi,

Shae the link from where i can download your PBI file.