Plotting the carry month over month total

[Anonymous]

I am currently working with a table that shows the details between when a work item is open and resolved. Each work item has a distict work item ID. I need to be able to sum up the work IDs by month to show what was open, closed, and the carry over total from month to month. I would like to be able to plot the carry over totals. 

Example table:

Date	Total Open	Total Closed	Change between open and closed	Carry Over
Jan	14899	12868	2031	2031
Feb	15022	15275	-253	1778
Mar	12704	12827	-123	1655
Apr	13670	12353	1317	2972
May	15772	15138	634	3606
Jun	11613	14465	-2852	754
Jul	10176	9059	1117	1871

I have currently tried to use the below measure but it is only summing up the work IDS by the created date. It is not showing the carry over total. 

VAR minDate =
CALCULATE (
MIN ( WorkOrder[CREATE_DT_TM] ),
ALLSELECTED ( WorkOrder[CREATE_DT_TM] )
)
RETURN
CALCULATE (
COUNTROWS(WorkOrder),
FILTER (
ALL ( WorkOrder[CREATE_DT_TM] ),
WorkOrder[CREATE_DT_TM] >= minDate
&& WorkOrder[CREATE_DT_TM] <= MAX ( WorkOrder[CREATE_DT_TM] )
)
)

[Anonymous]

Hi @parry2k Parry2k,

Here is an example of my raw data :

CREATE_DT_TM	Work_Order_ID	BREAK_STATUS_CD	BREAK_RESOLUTION_DT
7/23/2019	193815	RESOLVED	7/24/2019
7/23/2019	139375	RESOLVED	7/24/2019
7/23/2019	194861	RESOLVED	7/24/2019
7/23/2019	194862	RESOLVED	7/24/2019
7/23/2019	188438	RESOLVED	7/24/2019
7/23/2019	167442	RESOLVED	7/24/2019
7/23/2019	195290	RESOLVED	7/24/2019
7/23/2019	195106	RESOLVED	7/24/2019
7/23/2019	162434	OPEN
7/23/2019	182698	OPEN
7/23/2019	118778	OPEN
7/23/2019	177802	OPEN
7/23/2019	56550	OPEN
7/23/2019	56489	OPEN
7/23/2019	56025	OPEN

[parry2k]

@Anonymous can you share sample of your raw data?