Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper 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  0h 1m 2s

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

 

etc....

 

Thanks,

S

Need Help

1 Reply

  • Vicky_Song's avatar
    Vicky_Song
    Icon for Impactful Individual rankImpactful 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.