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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I get this error:

 

The syntax for 'DATEDIFF' is incorrect. (DAX(var _PreviousTime = CALCULATE(MAX(DataView[CommTimeStamp]), FILTER(DataView, EARLIER(DataView[CommTimeStamp]) > DataView[CommTimeStamp]))returnIF(ISBLANK(_PreviousTime), 0. DATEDIFF(_PreviousTime, DataView[CommTimeStamp], MINUTE)))).
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

are you copying and pasting correctly?

 

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