Report on time intervals

[SachinC]

Hi,

I have a column with values date/time stamp:  dd/mm/yyyy hh:mm:ss.

I want to report on intervals (hh:mm:ss) between rows, i.e:-

 row 1:  06/05/2016 09:33:33

 row 2:  06/05/2016 09:36:35  0h 1m 2s

 row 3:  06/05/2016 09:37:38  0h 1m 3s

etc....

Thanks,

S

[Vicky_Song]

Please follow steps below:

1). Sort that datetime column desc. 

2). Add an Index column. Click Edit Queries -> Add Column -> Add Index Column named Index.

3). Create a calculated column with. CreateTime column contains data with datetime type.

CustomCol = DATEDIFF((IF('Table'[Index] = 1,'Table'[CreateTime], LOOKUPVALUE('Table'[CreateTime],'Table'[Index],'Table'[Index]-1))),'Table'[CreateTime],minute)

Then you get the datetime difference in minutes. You can then create another calculated column to show the values with xxH xxMins format.