Calculate value between date time

[Rudy_CAG]

Hello,

i need to calculate the value between two date_time. My file:

Name	Date time	Value
A	20/02/16 12:10:00	100
A	20/02/16 12:20:00	110
A	20/02/16 12:30:00	125
B	20/02/16 08:50:00	60
B	20/02/16 09:00:00	85

i need to calculate the difference between the interval of 10mn in a new column. If someone could help...

Thanks in advance

Rudy

[Greg_Deckler]

So what results are you expecting? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

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

[Rudy_CAG]

As it's easy to calculate the value betweew two columns, it's a little bit difficult to do the same calcul between two lines. 

The expecting result is to create a new column which calculate the difference between a line data (for examble the 2nd line of the below table) and the line 10 mn before. For example: 

For Name "A": (20/02/16 12:20:00) - (20/02/16 12:10:00) = 110 - 100 = 10

Hope i was clear...