Row and Columns

Hi udurrani ,

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

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

Then, create measure named Attriton rate to get the attriton rate between years.

Attriton rate =

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

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

return

IF(_previous<>BLANK(),DIVIDE(_current-_previous,_previous,0),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/EWL26RFMgEJFm858qtN-b-sBkzdi7_wDpLrZ-Hd1wS7v-g?e=S3cOMG

Best Regards,

Amy

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