Cumulative total of text entry

[chydewf1]

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

[MFelix · Accepted 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