topic Calculate total hours each ID spends in each status in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-total-hours-each-ID-spends-in-each-status/m-p/4923861#M186887 <P>Hello, I have looked through the forums but am not quite finding my situation...</P><P>&nbsp;</P><P>I have the sample table below, which tracks multiple IDs moving through various statuses in a process. I would like to create a calculated column (TOTAL_TIME_IN_STATUS) which is the far right column below. I have populated a few expected results on the two sets of IDs. This is based on the next ID update record's timestamp.&nbsp;</P><P>&nbsp;</P><P>I might also want the option to either show total minutes or total hours for each status record. Any help is greatly appreciated!</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>ID</STRONG></TD><TD><STRONG>TIME_STAMP</STRONG></TD><TD><STRONG>STATUS</STRONG></TD><TD><STRONG>TOTAL_TIME_IN_STATUS (minutes)</STRONG></TD></TR><TR><TD>INPR0006238-1</TD><TD>10/28/2025 17:02</TD><TD>DISC_INITIATION</TD><TD>&nbsp;32</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/28/2025 17:34</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 6:36</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 6:36</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:31</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:31</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:38</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:38</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 11:01</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 11:01</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 12:42</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 12:42</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:02</TD><TD>DISC_QE</TD><TD>&nbsp;2</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:04</TD><TD>DISC_INITIATION</TD><TD>&nbsp;0</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:04</TD><TD>DISC_QE</TD><TD>&nbsp;104</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/8/2026 16:58</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/8/2026 16:58</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/9/2026 8:10</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/9/2026 8:10</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:18</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:18</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:53</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:53</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:02</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:02</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:47</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:47</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 10:21</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 10:21</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 10:22</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 10:22</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 11:57</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 11:57</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 12:02</TD><TD>CR</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 12:02</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:25</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:25</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:38</TD><TD>CR</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:38</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 23 Jan 2026 03:34:44 GMT data_guy_87 2026-01-23T03:34:44Z Calculate total hours each ID spends in each status https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-total-hours-each-ID-spends-in-each-status/m-p/4923861#M186887 <P>Hello, I have looked through the forums but am not quite finding my situation...</P><P>&nbsp;</P><P>I have the sample table below, which tracks multiple IDs moving through various statuses in a process. I would like to create a calculated column (TOTAL_TIME_IN_STATUS) which is the far right column below. I have populated a few expected results on the two sets of IDs. This is based on the next ID update record's timestamp.&nbsp;</P><P>&nbsp;</P><P>I might also want the option to either show total minutes or total hours for each status record. Any help is greatly appreciated!</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>ID</STRONG></TD><TD><STRONG>TIME_STAMP</STRONG></TD><TD><STRONG>STATUS</STRONG></TD><TD><STRONG>TOTAL_TIME_IN_STATUS (minutes)</STRONG></TD></TR><TR><TD>INPR0006238-1</TD><TD>10/28/2025 17:02</TD><TD>DISC_INITIATION</TD><TD>&nbsp;32</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/28/2025 17:34</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 6:36</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 6:36</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:31</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:31</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:38</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 10:38</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 11:01</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 11:01</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 12:42</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>10/29/2025 12:42</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:02</TD><TD>DISC_QE</TD><TD>&nbsp;2</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:04</TD><TD>DISC_INITIATION</TD><TD>&nbsp;0</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/6/2026 15:04</TD><TD>DISC_QE</TD><TD>&nbsp;104</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/8/2026 16:58</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/8/2026 16:58</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/9/2026 8:10</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/9/2026 8:10</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:18</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:18</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:53</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 7:53</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:02</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:02</TD><TD>DISC_INITIATION</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:47</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/15/2026 8:47</TD><TD>DISC_QE</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 10:21</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 10:21</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 10:22</TD><TD>MRB_T1</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 10:22</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 11:57</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 11:57</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 12:02</TD><TD>CR</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006073-4</TD><TD>1/19/2026 12:02</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:25</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:25</TD><TD>MRB_STRESS</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:38</TD><TD>CR</TD><TD>&nbsp;</TD></TR><TR><TD>INPR0006238-1</TD><TD>1/19/2026 12:38</TD><TD>MRB_T2</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 23 Jan 2026 03:34:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-total-hours-each-ID-spends-in-each-status/m-p/4923861#M186887 data_guy_87 2026-01-23T03:34:44Z Re: Calculate total hours each ID spends in each status https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-total-hours-each-ID-spends-in-each-status/m-p/4923885#M186890 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1258195" data-lia-user-login="data_guy_87" class="lia-mention lia-mention-user">data_guy_87</a>&nbsp;,</P><P>&nbsp;</P><P>Try like:</P><P>1) add a index column in Power Query. There are duplicate timestamps, otherwise we could rely on timestamp column to locate next rows.&nbsp;<BR />How:&nbsp;<A href="https://learn.microsoft.com/en-us/power-query/add-index-column" target="_blank" rel="noopener">https://learn.microsoft.com/en-us/power-query/add-index-column</A></P><P><BR />2) add a calculated column like:</P><LI-CODE lang="markup">Minutes = VAR _id = data[ID] VAR _index = data[Index] VAR _time = data[TIME_STAMP] VAR _next = MINX( FILTER( data, data[ID]=_id &amp;&amp;data[Index]&gt;_index ), data[TIME_STAMP] ) VAR _result = DATEDIFF(_time, _next, MINUTE) RETURN _result</LI-CODE><P>&nbsp;</P><P>it works like:</P><P><img /></P> Fri, 23 Jan 2026 04:00:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-total-hours-each-ID-spends-in-each-status/m-p/4923885#M186890 FreemanZ 2026-01-23T04:00:55Z