Forum Discussion
Calculating Time difference
Hi,
I am really struggling with some DAX formula's to calculate the difference in minutes between each of the previous rows.
For example, This tabke are checks which have to be completed every 60 minutes. I am trying to calculate how many minutes are between each. Then how many of those of checks lapse the 60 minute rule.
Any help on this would be appreciated!
Hi Todd23 ,
I've added the calculated column like below to obtain the previous test time.
Then, I subtracted the previous test time from the current test time to get the time elapsed since the last test:
For this exercise, I combined the date and time columns in order to deal with midnight testing scenarios (if it ever happens), even though the best practice is to separate out the date and time fields for reduced cardinarity.
I've also added a field to show which test exceeded 1 hour from the previous test.
I attach the pbix file in the link below:
1 Reply
Hi Todd23 ,
I've added the calculated column like below to obtain the previous test time.
Then, I subtracted the previous test time from the current test time to get the time elapsed since the last test:
For this exercise, I combined the date and time columns in order to deal with midnight testing scenarios (if it ever happens), even though the best practice is to separate out the date and time fields for reduced cardinarity.
I've also added a field to show which test exceeded 1 hour from the previous test.
I attach the pbix file in the link below: