Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate difference in minutes

I wanna know from the Datestamp coulmn see how much minute difference it's between the previous value and the last one. I tried this formula below but got totaly different value.   Datediff = DAT...
Need Help
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

Is the column formatted as a Date type?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

^^

yes it is.

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    7 years ago

    Can you provide some sample data and your expected result?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      So that is that column, new data comes in every 5 min for each sensor and so on, but not alawys (sometime it drops or coming late) so I wanna make a new column to see how much it's difference between previous and the new datestamp by minutes.

      • hnguy71's avatar
        hnguy71
        Icon for Super User rankSuper User
        7 years ago

        Try this:

        In a calculated column:

        TimeDiff = 
var _PreviousTime = CALCULATE(MAX(Table2[CommTimeStamp]), FILTER(Table2, EARLIER(Table2[CommTimeStamp]) > Table2[CommTimeStamp]))
return
IF(ISBLANK(_PreviousTime), 0, DATEDIFF(_PreviousTime, Table2[CommTimeStamp], MINUTE))