Forum Discussion
Accumolate exceeding cases
Hi Eric_Zhang,
I already used this messaure.
It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.
I want to see the trend in monthly view,
current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.
heres a glanss of the data:
| createdon | Acc exceeding cases | severitycodename |
| 29/02/2016 15:03 | 1 | Severity 2 - Medium |
| 15/03/2016 08:56 | 1 | Severity 2 - Medium |
| 18/03/2016 14:16 | 1 | Severity 3 - Low |
| 18/03/2016 14:47 | 1 | Severity 2 - Medium |
| 14/04/2016 12:50 | 1 | Severity 2 - Medium |
| 15/04/2016 08:25 | 1 | Severity 2 - Medium |
| 22/04/2016 08:51 | 1 | Severity 2 - Medium |
| 06/05/2016 14:26 | 1 | Severity 2 - Medium |
| 09/05/2016 15:20 | 1 | Severity 2 - Medium |
| 16/05/2016 10:55 | 1 | Severity 2 - Medium |
| 16/05/2016 10:59 | 1 | Severity 3 - Low |
| 16/05/2016 11:05 | 1 | Severity 2 - Medium |
| 17/05/2016 13:27 | 1 | Severity 2 - Medium |
| 30/05/2016 05:04 | 1 | Severity 2 - Medium |
| 30/05/2016 05:37 | 1 | Severity 2 - Medium |
| 02/06/2016 13:16 | 1 | Severity 2 - Medium |
| 03/06/2016 14:28 | 1 | Severity 2 - Medium |
| 06/06/2016 15:42 | 1 | Severity 2 - Medium |
| 07/06/2016 08:33 | 1 | Severity 2 - Medium |
| 08/06/2016 12:29 | 1 | Severity 2 - Medium |
| 08/06/2016 12:35 | 1 | Severity 2 - Medium |
| 09/06/2016 12:38 | 1 | Severity 2 - Medium |
| 10/06/2016 07:43 | 1 | Severity 2 - Medium |
| 14/06/2016 11:43 | 1 | Severity 2 - Medium |
| 15/06/2016 09:33 | 1 | Severity 2 - Medium |
| 21/06/2016 07:39 | 1 | Severity 2 - Medium |
| 21/06/2016 14:19 | 1 | Severity 1 - High |
| 24/06/2016 10:31 | 1 | Severity 2 - Medium |
| 27/06/2016 10:23 | 1 | Severity 2 - Medium |
| 27/06/2016 10:29 | 1 | Severity 2 - Medium |
| 29/06/2016 14:57 | 1 | Severity 2 - Medium |
| 29/06/2016 14:59 | 1 | Severity 1 - High |
| 30/06/2016 07:31 | 1 | Severity 1 - High |
| 30/06/2016 10:46 | 1 | Severity 1 - High |
| 30/06/2016 18:33 | 1 | Severity 2 - Medium |
| 30/06/2016 19:50 | 1 | Severity 2 - Medium |
| 04/07/2016 09:46 | 1 | Severity 2 - Medium |
| 05/07/2016 09:26 | 1 | Severity 2 - Medium |
| 08/07/2016 09:11 | 1 | Severity 1 - High |
| 08/07/2016 09:28 | 1 | Severity 2 - Medium |
| 11/07/2016 14:39 | 1 | Severity 2 - Medium |
| 11/07/2016 14:44 | 1 | Severity 3 - Low |
| 19/07/2016 18:11 | 1 | Severity 1 - High |
| 20/07/2016 19:25 | 1 | Severity 2 - Medium |
| 21/07/2016 07:10 | 1 | Severity 2 - Medium |
| 22/07/2016 12:50 | 1 | Severity 2 - Medium |
| 22/07/2016 13:21 | 2 | Severity 2 - Medium |
| 23/07/2016 16:10 | 1 | Severity 2 - Medium |
| 27/07/2016 08:25 | 1 | Severity 2 - Medium |
| 27/07/2016 09:03 | 1 | Severity 2 - Medium |
| 27/07/2016 15:11 | 1 | Severity 2 - Medium |
| 29/07/2016 13:07 | 1 | Severity 2 - Medium |
| 29/07/2016 13:51 | 1 | Severity 2 - Medium |
| 29/07/2016 14:00 | 1 | Severity 2 - Medium |
| 29/07/2016 14:08 | 1 | Severity 2 - Medium |
| 01/08/2016 11:19 | 1 | Severity 2 - Medium |
| 01/08/2016 11:33 | 1 | Severity 2 - Medium |
| 02/08/2016 13:29 | 1 | Severity 2 - Medium |
| 03/08/2016 21:30 | 1 | Severity 2 - Medium |
| 08/08/2016 21:22 | 1 | Severity 2 - Medium |
| 10/08/2016 15:39 | 1 | Severity 2 - Medium |
| 17/08/2016 20:39 | 1 | Severity 2 - Medium |
| 22/08/2016 13:48 | 1 | Severity 2 - Medium |
| 26/08/2016 19:47 | 1 | Severity 2 - Medium |
| 09/09/2016 10:13 | 1 | Severity 2 - Medium |
| 13/09/2016 10:54 | 1 | Severity 3 - Low |
| 14/09/2016 09:23 | 1 | Severity 1 - High |
| 19/09/2016 11:09 | 1 | Severity 2 - Medium |
| 19/09/2016 19:23 | 1 | Severity 2 - Medium |
| 21/09/2016 19:21 | 1 | Severity 2 - Medium |
| 22/09/2016 09:42 | 1 | Severity 2 - Medium |
| 23/09/2016 09:25 | 1 | Severity 2 - Medium |
| 27/09/2016 15:31 | 1 | Severity 2 - Medium |
Noak wrote:
Hi Eric_Zhang,
I already used this messaure.
It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.
I want to see the trend in monthly view,
current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.
What do you mean a trend then? May be a increasing or dropping percentage of each month?
@v-lvzhan-msft wrote:What do you mean a trend then? May be a increasing or dropping percentage of each month?
I mean if increasing Eric_Zhang. do you have any solution for that?