Variance in consecutive rows for dates

Question

Dear All,&nbsp;Hope you all are keeing well.I am new to PowerBI and facing one problem at the moment. It'd be really great help if you can help/ guide on this.I want to compare two dates and find the difference in days for consecutive rows. I am getting wrong results.The tables below shows the data. Variance for the first row shall be zero and going forward is shall be calulated for every row comparing previous row. If you see the difference between the variance from row 2 values is correct but the first row is getting compared to something else.&nbsp;The data is sorted with REF Date.&nbsp;Both REF Date and Start date come from different tables.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Your help will be really great in this.Thanks in advance.&nbsp;Kind RegardsRakesh&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Would be best if you had an Index column.&nbsp;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

Forum Discussion

Variance in consecutive rows for dates

1 Reply

Related content

Group rows with same dates and consecutive dates

Counting consecutive dates

Filtering Consecutive Dates by a Measure

Changing consecutive dates to from dates

Conditional sum: Consecutive date and non-consecutive date