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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Giavo

 

When you group by IWC number, what dates do you want to compare?

  • Giavo's avatar
    Giavo
    Helper III
    8 years ago

    after having the first formula (datediff between row and row+1), i would like to see if i can sum this Minutes(datediff) for each "IWC Number". thanks

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      do you mean difference between row and (row -1), not row + 1

      • Giavo's avatar
        Giavo
        Helper III
        8 years ago

        Isn't it the same thing?