Stacked chart with positive (additions) and negative (removals), plus running total

[Anonymous]

I'm running into a problem where I'm not sure how to get the removal data information to display correctly. For example, for ticket m1, the creation date falls properly in November, but on the chart the removal date also shows up in November vs December (I do have creationDate as the relation to the calendar so that's why it is occuring, but I don't know how to resolve).

May I please get your help with

1) I have creations charted in the month they were created, but how do I show removals in the month they were removed 

2) What would be the best way to create a running total to show how many tickets are currently open for a particuar month? Is the new window DAX function a good candidate for this?

Thank you

https://www.dropbox.com/s/ymmn9ma8z6haf1j/stacked%20chart%20with%20postive%20and%20negative%20and%20... 

This is what I'm trying to accomlish:

Example of what I'm trying to accomplish

But the problem is that removed tickets show up in the same month as when the IT ticket was created (and the rolling open Tickets is not properly working)

snippet of attached pbix

Data for cut & pasting into PBI:

entry	ticket#	creationDate	RemovalDate
1	m1	5-Nov-22	1-Dec-22
2	m2	28-Nov-22	2-Dec-22
3	m3	2-Dec-22	5-Dec-22
4	m4	5-Dec-22	20-Dec-22
5	m5	20-Dec-22	24-Dec-22
6	m6	25-Dec-22	4-Jan-23
7	m7	11-Jan-23	14-Jan-23
8	m8	14-Jan-23
9	m9	18-Jan-23
10	m10	20-Jan-23

visual table of the expected output:

For charting
Month	Additions	Removals	Rolling Open IT Tickets
2022-Nov	2	0	2
2022-Dec	4	-5	1
2023-Jan	4	-2	3

[lbendlin · Accepted solution]

You were almost there. Read about USERELATIONSHIP().

see attached.

[Anonymous]

Thank you, thank you, thank you!