Time difference between current output and previous output

[Karthik12]

Hello Folks,

My production server data has  time values in same coloumn (please refer attached picture).

Request your help to calculate the time difference between two outputs in my production data.

If one output was at 14:11 and another output is 14:14 means, I need to calculate the time between two outputs is 0.03 mins.

Like this, I need to calculate top 3 time difference of the selected day.

Is it possible?

Can you please support?

[v-yalanwu-msft · Accepted solution]

Hi, @Karthik12 ;

You could try it.

1.create a column

diff = 
var _last=
CALCULATE(MAX('Table'[Time]),FILTER('Table',[Time]<EARLIER('Table'[Time])&&[Date]=EARLIER('Table'[Date])))
return DATEDIFF(_last,[Time],SECOND)

2.set top 3:

If the above one can't help you get the desired result, please provide a simple and your expected result with backend logic and special examples.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Karthik12]

Hello @v-yalanwu-msft Thank you so much for the support. 

I have tried to attach my pbix file but couldn't find option.

So, attached as image.

I would like to get support for a time line graph for time intervals between latest time and previous time.

like below. Obvisiouly, first part time interval should be calculated as shift start time as indicated below.

 Hope this data give some clarity to you. If not, any alternate way to send pbix file to you?

Thanks in advance for your kind support !