Calculating the total duration of a status per machine

[DeRooy-Koen]

I would like to create a report that provides a clear overview of how much a particular machine has produced. Currently, I only have data that indicates when a certain machine received a status, but not when that status ended.

So, I want to know, for each line of data, (in a extra column) how long a particular status has lasted, and if it hasn't ended yet, how long it has been in that status.

Machine	MachineStatus	timestamp
14	IDLE	27-9-2023 14:56:12
17	PRODUCTIVE	27-9-2023 14:55:33
17	PRODUCTIVE_MIN	27-9-2023 14:55:28
14	PRODUCTIVE_MIN	27-9-2023 14:55:28
9	DOWN	27-9-2023 14:30:13
14	PRODUCTIVE_MIN	27-9-2023 14:30:05
14	IDLE	27-9-2023 14:29:40
14	PRODUCTIVE_MIN	27-9-2023 14:29:35
17	PRODUCTIVE	27-9-2023 14:28:50
17	PRODUCTIVE_MIN	27-9-2023 14:28:45
17	IDLE	27-9-2023 14:28:45
17	PRODUCTIVE_MIN	27-9-2023 14:28:42
17	IDLE	27-9-2023 14:28:42
17	PRODUCTIVE_MIN	27-9-2023 14:28:37
14	IDLE	27-9-2023 14:28:25
14	PRODUCTIVE	27-9-2023 14:28:05
14	PRODUCTIVE_MIN	27-9-2023 14:28:00
14	PRODUCTIVE	27-9-2023 14:27:55
14	PRODUCTIVE_MIN	27-9-2023 14:27:50
14	IDLE	27-9-2023 14:27:45
14	PRODUCTIVE_MIN	27-9-2023 14:27:43
8	PRODUCTIVE	27-9-2023 14:27:10
8	IDLE	27-9-2023 14:26:25
8	PRODUCTIVE	27-9-2023 14:25:55
8	PRODUCTIVE_MIN	27-9-2023 14:25:50
8	IDLE	27-9-2023 14:25:40
17	IDLE	27-9-2023 14:25:32
17	PRODUCTIVE_MIN	27-9-2023 14:25:32
8	PRODUCTIVE_MIN	27-9-2023 14:25:30
17	IDLE	27-9-2023 14:22:42
17	PRODUCTIVE_MIN	27-9-2023 14:22:40
17	IDLE	27-9-2023 14:22:26
17	PRODUCTIVE	27-9-2023 14:22:25
17	IDLE	27-9-2023 14:22:22
14	IDLE	27-9-2023 14:20:51
14	PRODUCTIVE_MIN	27-9-2023 14:20:50
8	IDLE	27-9-2023 14:20:43
8	PRODUCTIVE	27-9-2023 14:20:37
8	IDLE	27-9-2023 14:20:35
14	PRODUCTIVE	27-9-2023 14:20:07
8	PRODUCTIVE	27-9-2023 14:19:17
8	IDLE	27-9-2023 14:19:15
8	PRODUCTIVE	27-9-2023 14:19:15
14	IDLE	27-9-2023 14:19:14
8	IDLE	27-9-2023 14:19:13
14	PRODUCTIVE	27-9-2023 14:18:39
14	PRODUCTIVE_MIN	27-9-2023 14:18:34
8	IDLE	27-9-2023 06:44:47
8	PRODUCTIVE	27-9-2023 06:44:35
1	PRODUCTIVE	27-9-2023 06:44:00
1	IDLE	27-9-2023 06:43:57
1	IDLE	27-9-2023 06:43:57

My question to the community is whether I can achieve this with Power BI, and if so, how?

Could you please assist me with this?

[Anonymous]

Hi @DeRooy-Koen ,

Sorry, so far, to my knowledge, this may not be achieveable.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.