Open vs Resolved Tickets - Column chart

[ShaneP09]

Hi, and thanks in advance for your help!

I've ran through a few posts on the PBI board but still struggling to get my report/data to display correctly. The goal is to create a column chart with tickets opened (Created) vs tickets resolved, over time, from the 'Rapid' data set, grouped by 'Month Year'.  

I've created a date table, and linked the relationships via the Created (active) and Resolved (non-active) columns in the 'Rapid' table. I've also created a few measures to calculate the Open and Resolved totals.

Test Desktop report/data can be found here: One Drive pbix link - test data

You can see in the below table it is only linking one 'Resolved' ticket to a date. 

Any suggestions/tips would be awesome. Thanks again

[lbendlin]

The download link is not valid.