Need Help with hour calculation between state

Question

Hello Experts, I have below table.id&nbsp; &nbsp; &nbsp; &nbsp;teamname&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;from&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;state1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/23/2023&nbsp; &nbsp; 7:15:21 PM&nbsp; &nbsp; &nbsp;04/23/2023&nbsp; 7:15:25&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/23/2023&nbsp; &nbsp; 7:15:25 PM &nbsp; &nbsp; 04/23/2023&nbsp; 7:16:01&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/23/2023&nbsp; &nbsp; 7:16:18 PM&nbsp; &nbsp; &nbsp;04/23/2023&nbsp; 11:59:59&nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;04/23/2023&nbsp; &nbsp; 7:16:01 PM&nbsp; &nbsp; &nbsp;04/23/2023&nbsp; 7:16:18&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In Progress1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;04/23/2023&nbsp; &nbsp; 7:16:18 PM&nbsp; &nbsp; &nbsp;04/23/2023&nbsp; 7:16:25&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In Progress2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/23/2023&nbsp; &nbsp; 3:15:23 PM&nbsp; &nbsp; &nbsp;03/23/2023&nbsp; 3:15:25&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03/23/2023&nbsp; &nbsp; 3:15:26 PM &nbsp; &nbsp; 03/23/2023&nbsp; 3:16:01&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/23/2023&nbsp; &nbsp; 3:16:19 PM&nbsp; &nbsp; &nbsp;03/23/2023&nbsp; 3:59:55&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pending2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/23/2023&nbsp; &nbsp; 3:16:03 PM&nbsp; &nbsp; &nbsp;03/23/2023&nbsp; 3:16:22&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In Progress2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03/23/2023&nbsp; &nbsp; 3:16:23 PM&nbsp; &nbsp; &nbsp;03/23/2023&nbsp; 3:16:29&nbsp; &nbsp; PM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In ProgressNeed your help! I have date parameter from and to and I want to display pick time for each ID. The pick up time should count the difference from first in pending time minus first in progress state time for each team. how can I achieve that?

greg_deckler · Answer

davehardikkumar&nbsp;Strikes me as a variation of MTBF.&nbsp;See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.The basic pattern is:Column =&nbsp;&nbsp; VAR __Current = [Value]&nbsp; VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] &lt; EARLIER('Table'[Date])),[Date])&nbsp; VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])RETURN&nbsp; __Current - __Previous

Forum Discussion

Need Help with hour calculation between state

1 Reply

Related content

Calculation for Overall State

Button Slicer - State disabled

MoM calculation

Calculation Help

Calculating public holidays based on employee state