Forum Discussion

tameemyousaf's avatar
tameemyousaf
Helper I
5 years ago
Solved

Difference Between Two Dates in Single Column

Hi, I have data that has timestamp in sigle row. I want to calculate the difference (in seconds or minuites) between two timestamps and need to show in another column or measure. Can anyone please h...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi tameemyousaf ,

     

    Check the formula.

    Column = 
var lasttime = CALCULATE(MAX('Table'[timestamp]),FILTER('Table','Table'[timestamp]<EARLIER('Table'[timestamp])))
return
IF(ISBLANK(lasttime),BLANK(),DATEDIFF(lasttime,'Table'[timestamp],MINUTE))

     

    Best Regards,

    Jay

tameemyousaf's avatar
tameemyousaf
Helper I
5 years ago

Fowmy Thanks for your reply. I have only one timestamp column. In this case what will be the value of _dateTime variable.

Fowmy's avatar
Fowmy
Super User
5 years ago

tameemyousaf 

This should work:

Difference = 
var __datetime = Table20[DateTime]
var __predatetime = 
    MAXX(
        FILTER(
            ALL(Table20[DateTime]),
            Table20[DateTime] < __datetime
        ),
        Table20[DateTime]
    )
return
    DATEDIFF( __predatetime,__datetime,SECOND )