Issue with the cummulative dates in power BI

[gauri]

Hi all,

I am facing certain issue in how to programtically to this in Power Bi. Sharing a Screen shot for the same.

If you check the STARTDTM, ENDDTM and ENDREASON

so where my ENDREASON Column says Out for that particular time entry it is correct but where it says as missedout the time entries i.e. the start time and end time are wrong. If we consider the first row we have a STARTDTM of 6.30 and ENDDTM of 8.00 , so next entry should take STRTDTM of 8.00 which i this case it is taking as 23.15.

So basically if my ENDREASON = missedout then the STARTDTM should take the privious entry's end time and ENDDTM for missedout entry should be 23.15 in this case.

Can anyone help me with Dax or logic which can be implemeted in Power BI.

Thanks,

Gauri

[Greg_Deckler]

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...

If you have something that defines "previous" then the techniques in that article will work.