Forum Discussion
Calculate value between date time
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/339586
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...
