How to calculate variance per each row with date/time?

[Anonymous]

Hello all,

I am quite new in PowerBI and i would like to calculate the differences between each rows from column STARTDATE.

for example the output between taskid 4 and 5 is 00:01 minute or 1 as whole number.

Any suggestions?

Many thanks!

 

[Greg_Deckler · Accepted solution]

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...