Forum Discussion

dbravo's avatar
dbravo
Frequent Visitor
9 years ago
Solved

Calculate time difference with other rows

Hi,

 

I have a case tracking system that stores the date when a case passes from a state to another in a single row, then I want to calculate the duration time between state changes.

 

I have data like these:

 

id	case_id	date	state_id
25413857	802893	2017-06-01 00:00:02	1
25413858	802937	2017-06-01 00:00:02	1
25413859	889015	2017-06-01 00:00:08	1
25413860	889015	2017-06-01 00:00:57	2
25413861	889030	2017-06-01 00:01:43	1
25413862	889375	2017-06-01 00:01:59	1
25413863	889375	2017-06-01 00:02:00	2
25413864	889030	2017-06-01 00:02:18	2
25413865	889030	2017-06-01 00:02:19	3
25413866	889031	2017-06-01 00:02:36	1
25413867	889031	2017-06-01 00:03:20	2
25413868	889031	2017-06-01 00:03:21	3
25413869	889376	2017-06-01 00:03:23	1
25413870	889376	2017-06-01 00:03:24	2
25413871	889377	2017-06-01 00:03:46	1
25413872	889377	2017-06-01 00:03:47	2
25413873	889375	2017-06-01 00:03:50	3
25413874	889375	2017-06-01 00:03:52	4
25413875	889375	2017-06-01 00:04:02	5
25413876	889375	2017-06-01 00:04:03	6
25413877	889376	2017-06-01 00:04:54	3
25413878	889376	2017-06-01 00:04:55	4
25413879	889378	2017-06-01 00:05:08	1
25413880	889378	2017-06-01 00:05:09	2
25413881	889379	2017-06-01 00:05:21	1
25413882	889343	2017-06-01 00:05:27	1
25413883	889376	2017-06-01 00:05:27	5
25413884	889376	2017-06-01 00:05:32	6
25413885	802867	2017-06-01 00:05:38	1
25413886	889346	2017-06-01 00:05:42	1
25413887	889376	2017-06-01 00:05:43	7
25413888	889379	2017-06-01 00:05:51	2
25413889	888432	2017-06-01 00:06:02	1
25413890	889376	2017-06-01 00:06:07	8
25413891	889376	2017-06-01 00:06:08	9
25413892	888432	2017-06-01 00:06:09	2
25413893	889154	2017-06-01 00:06:31	1
25413894	889154	2017-06-01 00:06:32	2
25413895	889379	2017-06-01 00:06:33	3
25413896	889381	2017-06-01 00:06:38	1
25413897	889381	2017-06-01 00:06:39	2
25413898	889154	2017-06-01 00:06:40	3
25413899	889377	2017-06-01 00:06:46	3
25413900	889377	2017-06-01 00:06:48	4
25413901	889154	2017-06-01 00:06:52	4
25413902	889154	2017-06-01 00:06:53	5
25413903	889377	2017-06-01 00:06:55	5
25413904	889377	2017-06-01 00:06:56	6
25413905	889378	2017-06-01 00:07:29	3
25413906	889378	2017-06-01 00:07:30	4

 

I'm lost, I've tried using some DAX functions but I can't solve this, I hope you can help me.

 

Thanks in advance.