Forum Discussion
Extract Ticket Status from Noncontiguous Entries
samnf 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 __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __Previous
Greg_Deckler Hello Greg, thank you for your time, this is almost what I am looking for, to be more specific, when I implemented part of the calculated column I got the following outputs:
As seen here, project ID 3 has one of it's previous status' as On-Hold:
while it never got an on-hold entry, essentially for every entry, based on ID I'm interested in finding the previous status and previous entry date, keeping in mind that there might be more than a single day delay between an entry and another (noncontinguous).
The follow up question is, instead of having this as a calculated column, how can I approach it as an added column on power query editor. Thank you again.