Find Next Row by datetime

[power_roboter]

Hi experts,
I'm trying to find with dax for each row (each row represents a request) the next row based on the column "created".

Example:

For the first row with the requestId "fd8af..." the nextRequestId should be "548ea...".

Could you please help how to calcuate this with dax?

I tried Calculate(min(requests(created), ALLEXCEPT(requests,requests[userId]) Filter....) but this doesnt work.

[amitchandak]

@power_roboter , Create a new column like

maxx(filter(requests,[userId] = earlier([userId]) && [created] > earlier([created])),[created])

[Greg_Deckler · Accepted solution]

@power_roboter See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:

Column = 
  VAR __Current = [Value]
  VAR __NextDate = MINX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
  VAR __Next = MAXX(FILTER('Table',[Date]=__NextDate),[Value])
RETURN
  __Next