Forum Discussion

Giavo's avatar
Giavo
Helper III
8 years ago
Solved

DATEDIFF between Rows and GROUP BY

Hello everybody. 2 DAX Questions about DATEDIFF. 1)I need to find the difference in minutes between the rows of "DateTime" column 2)I need to find the difference in minutes between the rows of "Dat...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here is the output i see on my end from your data

parry2k's avatar
parry2k
Super User
8 years ago

try this,  in query editor, add a index column , then add following measure

 

Minute Diff = 
var prevRowDate = CALCULATE(MAX(x[DateTime]), Filter(ALLSELECTED(x), x[Index] < MAX( x[Index]))) 
return datediff(prevRowDate, max(x[DateTime]), MINUTE)
Giavo's avatar
Giavo
Helper III
8 years ago

Hi parry2k, thank you again for your help. Unfortunately it didn't work today on my project at work because it says that the Start date can not be after the End date

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Giavo seems like your rows contains the data where current row date/time value is less than previous row date/time value? Do you think that is possible, if yes then need to tweak the datediff formula.