Forum Discussion
Calculate difference between two status changes
Hi, I foolishly 'broke' a powerbi report by accidentally deleting a query and additional columns I'd added by using Google & this forum I now can't find the right answer I have a sharepoint lis...
Is this what you mean? I opened advanced editor from the query:
let
Source = SharePoint.Tables("https://nhs.sharepoint.com/sites/*********", [Implementation="2.0", ViewMode="All"]),
#"b0118a61-d46c-4d5f-ade5-8b12eaec27f8" = Source{[Id="b0118a61-d46c-4d5f-ade5-8b12eaec27f8"]}[Items],
#"Removed Other Columns" = Table.SelectColumns(#"b0118a61-d46c-4d5f-ade5-8b12eaec27f8",{"Title", "Status", "Created", "Modified", "ID", "Version"})
in
#"Removed Other Columns"
TitleStatusCreatedModifiedIDVersionStatus Order
| 401 | For assessment | 25/01/2023 12:38:00 | 25/01/2023 12:38:00 | 3 | 1.0 | 3 |
| 301 | For assessment | 25/01/2023 13:16:00 | 25/01/2023 13:16:00 | 4 | 1.0 | 3 |
| 401 | Under investigation | 25/01/2023 13:16:00 | 25/01/2023 13:16:00 | 5 | 1.0 | 2 |
| 401 | For SLT review | 25/01/2023 14:53:00 | 25/01/2023 14:53:00 | 6 | 1.0 | 4 |
| 243 | Approved to next stage | 26/01/2023 10:35:00 | 26/01/2023 10:35:00 | 14 | 1.0 | 7 |
| 244 | Approved to next stage | 26/01/2023 10:35:00 | 26/01/2023 10:35:00 | 15 | 1.0 | 7 |
| 248 | Approved to next stage | 26/01/2023 10:40:00 | 26/01/2023 10:40:00 | 16 | 1.0 | 7 |
| 242 | Approved to next stage | 26/01/2023 11:11:00 | 26/01/2023 11:11:00 | 17 | 1.0 | 7 |
| 301 | Request completed | 23/02/2023 14:39:00 | 23/02/2023 14:39:00 | 18 | 1.0 | 10 |
| 301 | Request completed | 23/02/2023 14:39:00 | 23/02/2023 14:39:00 | 19 | 1.0 | 10 |
| 301 | Request received | 23/02/2023 14:44:00 | 23/02/2023 14:44:00 | 20 | 1.0 | 1 |
| 301 | For SLT review | 23/02/2023 14:46:00 | 23/02/2023 14:46:00 | 21 | 1.0 | 4 |
| 301 | Approved to next stage | 23/02/2023 14:48:00 | 23/02/2023 14:48:00 | 22 | 1.0 | 7 |
| 301 | Request now a project | 23/02/2023 14:49:00 | 23/02/2023 14:49:00 | 23 | 1.0 | 9 |
| 262 | Request received | 23/02/2023 15:23:00 | 23/02/2023 15:23:00 | 24 | 1.0 | 1 |
| 262 | Under investigation | 24/02/2023 08:44:00 | 24/02/2023 08:44:00 | 25 | 1.0 | 2 |
| 259 | Under investigation | 24/02/2023 08:44:00 | 24/02/2023 08:44:00 | 26 | 1.0 | 2 |
| 261 | Under investigation | 24/02/2023 08:44:00 | 24/02/2023 08:44:00 | 27 | 1.0 | 2 |
| 262 | For assessment | 01/03/2023 11:20:00 | 01/03/2023 11:20:00 | 28 | 1.0 | 3 |
| 240 | Request completed | 02/03/2023 15:20:00 | 02/03/2023 15:20:00 | 29 | 1.0 | 10 |
| 228 | Request completed | 02/03/2023 15:29:00 | 02/03/2023 15:29:00 | 30 | 1.0 | 10 |
| 232 | Approved to next stage | 08/03/2023 12:55:00 | 08/03/2023 12:55:00 | 32 | 1.0 | 7 |
| 233 | Approved to next stage | 08/03/2023 12:57:00 | 08/03/2023 12:57:00 | 33 | 1.0 | 7 |
| 236 | Approved to next stage | 08/03/2023 12:58:00 | 08/03/2023 12:58:00 | 34 | 1.0 | 7 |
| 252 | Approved to next stage | 08/03/2023 13:00:00 | 08/03/2023 13:00:00 | 35 | 1.0 | 7 |
| 253 | Approved to next stage | 08/03/2023 13:01:00 | 08/03/2023 13:01:00 | 36 | 1.0 | 7 |
| 254 | Approved to next stage | 08/03/2023 13:03:00 | 08/03/2023 13:03:00 | 37 | 1.0 | 7 |
| 255 | Approved to next stage | 08/03/2023 13:03:00 | 08/03/2023 13:03:00 | 38 | 1.0 | 7 |
| 256 | Approved to next stage | 08/03/2023 13:04:00 | 08/03/2023 13:04:00 | 39 | 1.0 | 7 |
| 257 | Approved to next stage | 08/03/2023 13:05:00 | 08/03/2023 13:05:00 | 40 | 1.0 | 7 |
| 258 | Approved to next stage | 08/03/2023 13:06:00 | 08/03/2023 13:06:00 | 41 | 1.0 | 7 |
| 265 | Under investigation | 09/03/2023 14:43:00 | 09/03/2023 14:43:00 | 42 | 1.0 | 2 |
| 264 | Under investigation | 09/03/2023 14:43:00 | 09/03/2023 14:43:00 | 43 | 1.0 | 2 |
| 229 | For SLT review | 09/03/2023 15:15:00 | 09/03/2023 15:15:00 | 44 | 1.0 | 4 |
| 266 | Under investigation | 14/03/2023 09:45:00 | 14/03/2023 09:45:00 | 45 | 1.0 | 2 |
| 263 | For SLT review | 14/03/2023 11:03:00 | 14/03/2023 11:03:00 | 46 | 1.0 | 4 |
| 229 | Approved to next stage | 14/03/2023 11:18:00 | 14/03/2023 11:18:00 | 47 | 1.0 | 7 |
| 266 | For assessment | 15/03/2023 10:38:00 | 15/03/2023 10:38:00 | 48 | 1.0 | 3 |
| 176 | Request completed | 17/03/2023 13:55:00 | 17/03/2023 13:55:00 | 49 | 1.0 | 10 |
| 213 | Request completed | 17/03/2023 16:25:00 | 17/03/2023 16:25:00 | 50 | 1.0 | 10 |
| 268 | For Clinical review | 23/03/2023 14:31:00 | 23/03/2023 14:31:00 | 51 | 1.0 | 5 |
| 208 | Request completed | 23/03/2023 16:13:00 | 23/03/2023 16:13:00 | 52 | 1.0 | 10 |
| 217 | Request completed | 23/03/2023 16:14:00 | 23/03/2023 16:14:00 | 53 | 1.0 | 10 |
| 243 | Request completed | 23/03/2023 16:19:00 | 23/03/2023 16:19:00 | 54 | 1.0 | 10 |
| 259 | For assessment | 24/03/2023 14:42:00 | 24/03/2023 14:42:00 | 55 | 1.0 | 3 |
| 265 | For SLT review | 28/03/2023 09:28:00 | 28/03/2023 09:28:00 | 56 | 1.0 | 4 |
| 267 | Approved to next stage | 28/03/2023 12:05:00 | 28/03/2023 12:05:00 | 57 | 1.0 | 7 |
| 263 | Approved to next stage | 28/03/2023 12:05:00 | 28/03/2023 12:05:00 | 58 | 1.0 | 7 |
| 264 | Approved to next stage | 28/03/2023 12:06:00 | 28/03/2023 12:06:00 | 59 | 1.0 | 7 |
| 260 | Approved to next stage | 28/03/2023 12:14:00 | 28/03/2023 12:14:00 | 60 | 1.0 | 7 |
| 271 | For assessment | 30/03/2023 09:42:00 | 30/03/2023 09:42:00 | 61 | 1.0 | 3 |
| 205 | Request completed | 31/03/2023 10:11:00 | 31/03/2023 10:11:00 | 62 | 1.0 | 10 |
| 227 | Request completed | 31/03/2023 14:27:00 | 31/03/2023 14:27:00 | 63 | 1.0 | 10 |
| 272 | Under investigation | 03/04/2023 10:24:00 | 03/04/2023 10:24:00 | 64 | 1.0 | 2 |
| 270 | For assessment | 03/04/2023 16:13:00 | 03/04/2023 16:13:00 | 65 | 1.0 | 3 |
| 271 | For SLT review | 04/04/2023 08:54:00 | 04/04/2023 08:54:00 | 66 | 1.0 | 4 |
| 270 | For SLT review | 04/04/2023 08:54:00 | 04/04/2023 08:54:00 | 67 | 1.0 | 4 |
| 259 | For SLT review | 04/04/2023 08:54:00 | 04/04/2023 08:54:00 | 68 | 1.0 | 4 |
| 268 | For assessment | 04/04/2023 15:35:00 | 04/04/2023 15:35:00 | 69 | 1.0 | 3 |
| 259 | Approved to next stage | 11/04/2023 10:17:00 | 11/04/2023 10:17:00 | 70 | 1.0 | 7 |
| 270 | Rejected | 11/04/2023 10:18:00 | 11/04/2023 10:18:00 | 71 | 1.0 | 6 |
| 271 | Approved to next stage | 11/04/2023 10:18:00 | 11/04/2023 10:18:00 | 72 | 1.0 | 7 |
| 265 | Approved to next stage | 11/04/2023 10:18:00 | 11/04/2023 10:18:00 | 73 | 1.0 | 7 |
| 165 | Request completed | 11/04/2023 14:22:00 | 11/04/2023 14:22:00 | 74 | 1.0 | 10 |
| 211 | Request completed | 11/04/2023 14:33:00 | 11/04/2023 14:33:00 | 75 | 1.0 | 10 |
| 174 | Approved to next stage | 11/04/2023 15:55:00 | 11/04/2023 15:55:00 | 76 | 1.0 | 7 |
| 275 | Under investigation | 12/04/2023 09:28:00 | 12/04/2023 09:28:00 | 77 | 1.0 | 2 |
| 246 | Rejected | 12/04/2023 09:42:00 | 12/04/2023 09:42:00 | 78 | 1.0 | 6 |
| 271 | Request now a project | 12/04/2023 11:20:00 | 12/04/2023 11:20:00 | 79 | 1.0 | 9 |
| 235 | Rejected | 12/04/2023 16:06:00 | 12/04/2023 16:06:00 | 80 | 1.0 | 6 |
| 275 | For Clinical review | 17/04/2023 11:35:00 | 17/04/2023 11:35:00 | 81 | 1.0 | 5 |
| 278 | For Clinical review | 17/04/2023 11:35:00 | 17/04/2023 11:35:00 | 82 | 1.0 | 5 |
| 273 | For Clinical review | 17/04/2023 11:35:00 | 17/04/2023 11:35:00 | 83 | 1.0 | 5 |
| 276 | Proceeded without SLT approval | 17/04/2023 13:36:00 | 17/04/2023 13:36:00 | 84 | 1.0 | 8 |
| 274 | For assessment | 17/04/2023 13:40:00 | 17/04/2023 13:40:00 | 85 | 1.0 | 3 |
| 274 | For SLT review | 18/04/2023 10:33:00 | 18/04/2023 10:33:00 | 86 | 1.0 | 4 |
| 277 | For SLT review | 18/04/2023 10:33:00 | 18/04/2023 10:33:00 | 87 | 1.0 | 4 |
| 209 | Request completed | 18/04/2023 12:40:00 | 18/04/2023 12:40:00 | 88 | 1.0 | 10 |
| 234 | Rejected | 18/04/2023 14:05:00 | 18/04/2023 14:05:00 | 89 | 1.0 | 6 |
| 171 | Rejected | 20/04/2023 09:39:00 | 20/04/2023 09:39:00 | 90 | 1.0 | 6 |
| 183 | Rejected | 20/04/2023 09:49:00 | 20/04/2023 09:49:00 | 91 | 1.0 | 6 |
| 231 | Rejected | 20/04/2023 09:51:00 | 20/04/2023 09:51:00 | 92 | 1.0 | 6 |
| 275 | For assessment | 20/04/2023 16:14:00 | 20/04/2023 16:14:00 | 93 | 1.0 | 3 |
| 278 | For assessment | 20/04/2023 16:14:00 | 20/04/2023 16:14:00 | 94 | 1.0 | 3 |
| 273 | For assessment | 20/04/2023 16:14:00 | 20/04/2023 16:14:00 | 95 | 1.0 | 3 |
| 178 | For assessment | 20/04/2023 16:15:00 | 20/04/2023 16:15:00 | 96 | 1.0 | 3 |
| 232 | For SLT review | 21/04/2023 12:36:00 | 21/04/2023 12:36:00 | 97 | 1.0 | 4 |
| 274 | Approved to next stage | 25/04/2023 09:45:00 | 25/04/2023 09:45:00 | 98 | 1.0 | 7 |
| 277 | Approved to next stage | 25/04/2023 09:45:00 | 25/04/2023 09:45:00 | 99 | 1.0 | 7 |