Forum Discussion

SachinC's avatar
SachinC
Helper V
10 years ago

Report on time intervals

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  0...
Need Help
Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

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.