Forum Discussion
Giavo
Helper III
Helper IIIDATEDIFF 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...
here is the output i see on my end from your data
GiavoHelper III
Helper IIIafter 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
Super Userdo you mean difference between row and (row -1), not row + 1
- Giavo
Isn't it the same thing?
- Giavo
yes you're right. Row and Row - 1
- parry2k
Giavo :manhappy:
Can you paste the data so that i can use that for calc instead of the image you pasted, or share excel file (using google drive or other means). cheers!
- Giavo
yes sure, thank you for helping
ProgressiveIndex IWC Number DateTime Status 1 100 13/10/17 7:10 1 2 100 13/10/17 9:04 3 3 100 13/10/17 9:10 3 1 103 13/10/17 9:18 2 2 103 14/10/17 9:21 5 3 103 14/10/17 9:31 7 1 106 14/10/17 9:50 31 2 106 14/10/17 10:09 21 3 106 14/10/17 11:02 43