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