Forum Discussion
Find Next Row by datetime
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.
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/339586.
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
2 Replies
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/339586.
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 __Nextpower_roboter , Create a new column like
maxx(filter(requests,[userId] = earlier([userId]) && [created] > earlier([created])),[created])
