Forum Discussion
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...
here is the output i see on my end from your data
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
do you mean difference between row and (row -1), not row + 1
Isn't it the same thing?
yes you're right. Row and Row - 1
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!
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