Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I'm trying to construct a running total of issues "open" or "closed".
I have a column of dates and a column containing text (either open or closed)
I want to plot two lines x axis should be date and y axis should be cummulative number of closed or open.
ie on a given date I want to know the total of open and closed up to that date.
Some sample data is below.
Thanks
Chris
Open/ClosedOpen/Closed Date
Closed | 09/11/2017 15:36:21 |
Closed | 16/11/2017 08:36:52 |
Open | 31/10/2017 15:10:33 |
Closed | 16/11/2017 09:19:26 |
Closed | 16/11/2017 09:02:46 |
Closed | 23/11/2017 10:47:57 |
Closed | 01/11/2017 16:07:12 |
Open | 01/11/2017 17:41:26 |
Open | 01/11/2017 18:52:17 |
Open | 01/11/2017 21:28:17 |
Open | 02/11/2017 07:24:04 |
Open | 02/11/2017 11:52:51 |
Open | 03/11/2017 19:19:14 |
Open | 03/11/2017 20:58:53 |
Open | 03/11/2017 21:03:02 |
Open | 03/11/2017 21:05:47 |
Open | 04/11/2017 05:20:01 |
Open | 04/11/2017 05:28:24 |
Open | 04/11/2017 05:45:35 |
Open | 04/11/2017 05:53:49 |
Open | 04/11/2017 06:13:48 |
Open | 04/11/2017 06:25:20 |
Closed | 06/11/2017 09:17:32 |
Closed | 13/11/2017 10:21:05 |
Open | 04/11/2017 12:47:09 |
Open | 04/11/2017 14:30:43 |
Open | 05/11/2017 01:03:15 |
Closed | 07/11/2017 16:13:10 |
Closed | 06/11/2017 16:58:16 |
Open | 06/11/2017 08:03:16 |
Open | 06/11/2017 08:08:20 |
Open | 06/11/2017 08:31:25 |
Closed | 06/11/2017 17:39:29 |
Open | 06/11/2017 14:22:47 |
Open | 06/11/2017 21:59:36 |
Open | 07/11/2017 22:12:50 |
Closed | 09/11/2017 09:39:55 |
Closed | 10/11/2017 12:33:02 |
Open | 08/11/2017 09:51:16 |
Closed | 10/11/2017 15:35:16 |
Open | 08/11/2017 14:59:55 |
Closed | 23/11/2017 16:13:31 |
Closed | 17/11/2017 15:53:54 |
Closed | 09/11/2017 17:55:40 |
Closed | 09/11/2017 17:57:08 |
Open | 09/11/2017 13:47:07 |
Open | 10/11/2017 05:21:46 |
Open | 10/11/2017 08:15:23 |
Open | 10/11/2017 08:42:44 |
Open | 10/11/2017 08:50:20 |
Open | 10/11/2017 08:58:45 |
Closed | 24/11/2017 18:28:15 |
Open | 10/11/2017 11:05:31 |
Open | 10/11/2017 11:12:12 |
Open | 11/11/2017 02:53:07 |
Open | 11/11/2017 13:56:28 |
Open | 12/11/2017 05:38:20 |
Closed | 15/11/2017 09:11:10 |
Open | 13/11/2017 22:45:47 |
Open | 14/11/2017 00:40:20 |
Open | 14/11/2017 06:00:49 |
Open | 14/11/2017 08:23:29 |
Open | 14/11/2017 08:27:31 |
Closed | 23/11/2017 17:21:40 |
Open | 14/11/2017 09:19:01 |
Open | 14/11/2017 09:20:28 |
Open | 14/11/2017 09:22:47 |
Open | 14/11/2017 09:23:54 |
Open | 14/11/2017 14:02:23 |
Closed | 16/11/2017 17:02:53 |
Open | 14/11/2017 16:11:03 |
Closed | 16/11/2017 08:58:38 |
Open | 14/11/2017 17:20:27 |
Open | 14/11/2017 20:44:08 |
Closed | 16/11/2017 09:32:47 |
Open | 15/11/2017 10:08:27 |
Open | 15/11/2017 10:43:41 |
Open | 15/11/2017 11:21:30 |
Open | 15/11/2017 14:27:53 |
Closed | 17/11/2017 16:16:04 |
Closed | 16/11/2017 08:44:53 |
Closed | 23/11/2017 17:41:26 |
Closed | 21/11/2017 17:23:10 |
Open | 16/11/2017 07:07:54 |
Closed | 21/11/2017 17:36:22 |
Open | 16/11/2017 11:54:40 |
Open | 16/11/2017 12:02:53 |
Open | 16/11/2017 13:43:03 |
Open | 18/11/2017 04:35:25 |
Open | 18/11/2017 09:53:33 |
Open | 18/11/2017 23:05:08 |
Open | 21/11/2017 06:54:08 |
Open | 21/11/2017 08:27:15 |
Closed | 23/11/2017 17:42:57 |
Open | 21/11/2017 12:24:32 |
Open | 21/11/2017 14:40:50 |
Open | 21/11/2017 14:53:45 |
Open | 21/11/2017 18:07:36 |
Open | 22/11/2017 08:26:54 |
Open | 22/11/2017 14:17:34 |
Open | 22/11/2017 16:12:08 |
Open | 22/11/2017 16:12:09 |
Open | 22/11/2017 17:00:01 |
Open | 22/11/2017 17:28:14 |
Open | 22/11/2017 21:20:29 |
Open | 23/11/2017 04:12:13 |
Open | 23/11/2017 08:28:03 |
Open | 23/11/2017 14:00:26 |
Open | 23/11/2017 16:40:43 |
Open | 23/11/2017 17:01:16 |
Open | 23/11/2017 18:04:23 |
Open | 23/11/2017 19:37:55 |
Open | 23/11/2017 22:36:18 |
Open | 24/11/2017 04:24:53 |
Open | 24/11/2017 23:40:53 |
Open | 25/11/2017 09:26:45 |
Open | 25/11/2017 11:32:42 |
Open | 25/11/2017 11:39:14 |
Open | 25/11/2017 19:51:30 |
Open | 26/11/2017 11:16:08 |
Open | 26/11/2017 12:26:07 |
Open | 26/11/2017 21:53:07 |
Open | 27/11/2017 06:12:19 |
Solved! Go to Solution.
Hi @chydewf1,
Just add this measure on your graph and then the open/close on legend:
Cumulative = VAR Max_Date = MAX ( Open_Closed[Date] ) RETURN CALCULATE ( COUNT ( Open_Closed[Status] ), Open_Closed[Date] <= Max_Date )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @chydewf1,
Just add this measure on your graph and then the open/close on legend:
Cumulative = VAR Max_Date = MAX ( Open_Closed[Date] ) RETURN CALCULATE ( COUNT ( Open_Closed[Status] ), Open_Closed[Date] <= Max_Date )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |