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 "DateTime" column GROUPING BY "IWC Number"
Can you please help me with DAX ?
Go to Solution.
here is the output i see on my end from your data
Proud to be a Datanaut! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
when you said difference, you mean difference in minute from current row datetime to previous row datetime
When you group by IWC number, what dates do you want to compare?
Proud to be a Datanaut!
Yes exactly, difference(in minutes) between row and row+1(i guess i should use DATEDIFF but i can't obtain the correct result.
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
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
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!