Forum Discussion

Giavo's avatar
Giavo
Icon for Helper III rankHelper 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

Giavo's avatar
Giavo
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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.