Forum Discussion
Helper IVcalculate duration
Hi alevandenes ,
Assuming the id column corresponds to the order of timestamps, you first need to calculate the start of each stop time where teamMember is equal to the current row teamMember and [id] is < the current row [id] and deduct that from stop. You can then sum the result of a calculated column and show it in a visual.
Pleasae see attached pbix for details.
Helper IV| id | entryType | timeStamp | teamMember |
| 4 | Start | 2023-10-16 13:19:45.628 | 12382 |
| 5 | Stop | 2023-10-16 13:21:10.793 | 12382 |
| 6 | Start | 2023-10-16 13:21:40.157 | 12382 |
| 7 | Stop | 2023-10-16 13:21:44.88 | 12382 |
| 8 | Start | 2023-10-16 13:22:28.313 | 16230 |
| 9 | Stop | 2023-10-16 13:23:24.242 | 16230 |
| 10 | Start | 2023-10-16 13:24:27.739 | 12073 |
| 11 | Start | 2023-10-16 13:26:05.893 | 16230 |
| 12 | Stop | 2023-10-16 13:26:23.473 | 12073 |
| 13 | Start | 2023-10-16 13:28:49.522 | 12382 |
| 14 | Stop | 2023-10-16 13:29:36.053 | 12382 |
| 15 | Start | 2023-10-16 13:29:48.392 | 12382 |
| 16 | Start | 2023-10-16 13:30:00.596 | 12382 |
| 17 | Stop | 2023-10-16 13:30:12.309 | 12382 |
| 18 | Start | 2023-10-16 13:30:16.384 | 12382 |
| 19 | Stop | 2023-10-16 13:30:57.837 | 12382 |
| 20 | Start | 2023-10-16 13:31:17.914 | 12382 |
Super UserHi alevandenes ,
Assuming the id column corresponds to the order of timestamps, you first need to calculate the start of each stop time where teamMember is equal to the current row teamMember and [id] is < the current row [id] and deduct that from stop. You can then sum the result of a calculated column and show it in a visual.
Pleasae see attached pbix for details.
- alevandenes
amazing! thanks a lot!