Hello everybody. 2 DAX Questions about DATEDIFF.1)I need to find the difference in minutes between the rows of "DateTime" column2)I need to find the difference in minutes between the rows of "DateTime" column GROUPING BY "IWC Number" Can you please help me with DAX ?

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

DATEDIFF between Rows and GROUP BY | Microsoft Fabric Community

parry2k
Super User
8 years ago
when you said difference, you mean difference in minute from current row datetime to previous row datetime
- Giavo
  Helper III
  8 years ago
  Yes exactly, difference(in minutes) between row and row+1(i guess i should use DATEDIFF but i can't obtain the correct result.
Phil_Seamark
Microsoft Employee
8 years ago
HI Giavo

When you group by IWC number, what dates do you want to compare?
- 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
    Super User
    8 years ago
    do you mean difference between row and (row -1), not row + 1
Anonymous
Not applicable
3 years ago
This is not helpful at all. Who approved this?