Forum Discussion
Solved
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......
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
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