Percentage growth in 5 years

[mohammedkhan]

I have Country Name and Years columns i want to show the Growth for each country in last 5 years 

[v-xicai · Accepted solution]

Hi mohammedkhan,

According to your description, I create sample data to reproduce the scenario. You can implement your demand following steps below.

Firstly, convert the column 2012-2017 to row data like picture below. Named the new column "Year", and change its data type to Whole Number.

Then, create measure named Year Growth to get the Growth for each country in last 5 years.

Year Growth =

VAR _previous = CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1), 'Table1'[Country Name]=MAX(Table1[Country Name])&&Table1[Year] = MAX(Table1[Year]) -1))

VAR _current = CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1),'Table1'[Country Name]=MAX(Table1[Country Name])&&Table1[Year] =MAX(Table1[Year])))

return

IF(_previous<>BLANK(),DIVIDE(_current,_previous,0)-1,BLANK())

Choose the table visual to display the result.

Here is my test pbix file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EfAtmoNdJf9Cl34-EE...

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.