Ticket date. Overlapping line chart.

Hi Community.

I have a large dataset of ticket info from our PSA tool that i'd like to plot into a line chart with two values of "tickets created" and "tickets Closed" that overlap each other.

The idea being we can see on any given day how many tickets were opened vs closed.

Also key is to have all the other ticket info in the dataset available so I can created a drill down so when you click the tickets opened for that day, it shows a table of all the tickets and all the info.

Below is an example of the chart visuals

Below is a small set of sample data. How can I get this data into a chart as described? I think I need to have a count of dates, then a sum of that count grouped by the distinct dates. Like so:

Can PowerBI do this on a DirectQuery?

I can't do the heavy lifting of the data in the datasource as above as there are a lot more columns that I want to keep in the full dataset so I can create a drill down with lots of ticket info.

The full list of columns in the data set:

Below is some sample data from a small portion of the available columns.