Stacked chart with positive (additions) and negative (removals), plus running total
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%20running%20total.pbix?dl=0 This is what I'm trying to accomlish: 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) 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
