it Calculate increase from previous row

[Anonymous]

Hi, 

I am trying to calculate the increase of my "Median of TTR" column over the grade before and show it in a new column:

So for grade 06 it would be: (18.049,42 (G06) - 9824,74 (G05)) / 9824,74 (G05) = 84%. 

How could I create a measure like this?

Please notice that for some cuts of my data, some grades will be missing, so it might go from grade 05 to 08, for example. In these cases, I won't need to show any increment.

Thanks!

[FarhanAhmed]

How is your data stored ?

What is the table structure?

What is the criteria of previous row ? is it grade or is it latest record via date ? A comp Grade is unique ?

Sample data of your full table would be nice.

[amitchandak]

@Anonymous , There is row manipulation

Create a rank as a column on the grade in table

Rank column = rankx(all(Table),[grade],,asc,dense)

Now use rank to have previous. row.

This grade= CALCULATE(sum('Table'[TTR]),filter(ALL('Table'[grade]),'Date'[Rank column]=max('Date'[Rank column])))
Last grade= CALCULATE(sum('Table'[TTR]),filter(ALL('Table'[grade]),'Date'[Rank column]=max('Date'[Rank column])-1))

or

This grade= CALCULATE(sum('Table'[TTR]),filter(ALL('Table'[Rank column]),'Date'[Rank column]=max('Date'[Rank column])))
Last grade= CALCULATE(sum('Table'[TTR]),filter(ALL('Table'[Rank column]),'Date'[Rank column]=max('Date'[Rank column])-1))

same as what I did in WOW

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123