topic Calculate value between date time in Developer

Calculate value between date time

Rudy_CAG — Mon, 16 Mar 2020 13:24:35 GMT

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

Re: Calculate value between date time

Greg_Deckler — Mon, 16 Mar 2020 13:40:30 GMT

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

Re: Calculate value between date time

Rudy_CAG — Wed, 18 Mar 2020 09:54:16 GMT

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