Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time differences between two date/time values in same column

How can I create a column that will provide the time elapsed between two cells. For example the difference in time between 1:35:21 and 2:20:47 in the second cell of the column labeled column  ...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

this column will return you time difference in seconds

Column = 
var _prevDate = calculate(max(Table1[Date/Time]);FILTER(ALL(Table1);Table1[Date/Time]<EARLIER([Date/Time])))
RETURN
DATEDIFF(_prevDate;Table1[Date/Time];SECOND)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am getting the error "There's not enough memory to complete this operation. Please try again later when there may be more memory available."

     

    Any way around this without reducing data size?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 'Clear Cache' from File--> Options