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

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI Giavo

 

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

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

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

      • Giavo's avatar
        Giavo
        Icon for Helper III rankHelper III
        8 years ago

        Isn't it the same thing?