Determine the next date a value appears

CVanpat91 — Sat, 07 May 2022 18:47:33 GMT

Hello,

I have a set of data where a certain value appears multiple times. I want to know the next date that the value appears. Example below of data.

Name	Date
Blue	1/1/2022
Red	8/4/2021
Blue	5/1/2021
Blue	4/2/2021
Green	4/1/2021
Green	2/3/2021

Example of what I need for results:

Name	Date	Next Date
Blue	1/1/2022	null
Red	8/4/2021	null
Blue	5/1/2021	1/1/2022
Blue	4/2/2021	5/1/2021
Green	4/1/2021	null
Green	2/3/2021	4/1/2021

Any help would be greatly appreciated. Thank you in advance!

Re: Determine the next date a value appears

tamerj1 — Sat, 07 May 2022 19:15:56 GMT

Hi CVanpat91

you can create new column

Next Day = VAR NameTable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[Name] ) ) VAR NextDatesTable = FILTER ( NameTable, Data[Date] > EARLIER ( Data[Date] ) ) VAR NextDate = MINX ( NextDatesTable, Data[Date] ) RETURN NextDate

topic Re: Determine the next date a value appears in DAX Commands and Tips

Determine the next date a value appears

Re: Determine the next date a value appears