Help Getting the % Change Between Two Dates, but filtering based on name?

[3lj]

Hi,

This is my table, it has:

- date index - that dynamically changes to show the latest date as 0.

- The date

- A name

- % Complete that week.

What I am trying to make is a column/measuer that tells me the weekly change based on the Name, between the previous date index (current row index + 1) and the current date (index 0) - as highlighted in red.

I'm guessing we also have to handle error cases for the "last" one, where there is no index +1 too?

I think I need to create a measure in three parts, one for the current % complete, one for the previous % complete (but somehow fitler based on the name of the current row and the index beign the current row's index +1, then the calcualting to subtract the two)

Any hints or thoughts?

Date Index	Date	Name	% Complete	Weekly Change
0	26/04/23	Anna	100	+10
0	26/04/23	Beth	50	+0
0	26/04/23	Caroline	50	+50
1	25/04/23	Anna	90
1	25/04/23	Beth	50
1	25/04/23	Caroline	0

[lbendlin]