Evaluate items in a table and classify status Month over Month (Existing - New - Closed)

[maindaco]

I have a single table with a list of cases that will grow up along the time. Table contains some relevant fields like "CaseID", "Opened Date", "Closed Date", etc. I need to identify for Month 1 the composition based on it's status (New and Closed), for next month (Month 2) data needs to be compared with previous month to split the totals in New, Current, Closed cases and so on (next month should compare with previous month and split cases in the mentioned Categories (aka Status). Of course, this will be used later for creating visuals (e.g. stacked bars to compare months). I guess a new column or measure needs to be created, but I'm not an expert in DAX. Thanks for the help.

PS, I tried looking for a similar scenario in the forum, but had no luck with it.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523