How I get next date value according to row value

[Julio_Moyano]

Hi

I am trying to get the next date value for each people

I have tried to make a VC, but I got me the next row not the next row according to name

LOOKUP([_THISROW].[_RowNumber]+1, “table”, “_ROWNUMBER”, “date”)

I have a table like this:

name	date
julian	3/3/2022
julian	7/4/2022
Paul	10/3/2022
Mary	4/4/2022
John	3/5/2022
Mary	15/6/2022

the  desired outcome:

name	date	next date
julian	3/3/2022	7/4/2022
julian	7/4/2022
Paul	10/3/2022
Mary	4/4/2022	15/6/2022
John	3/5/2022
Mary	15/6/2022

thanks!

[graham_howe · Accepted solution]

Try the following

MINROW(
  "table", 
  "date", 
  AND(
    ([name] = [_THISROW].[name]),
    ([date] > [_THISROW].[date])
  )
)

[Julio_Moyano]

Thanks! @graham_howe