Tickets Closed and Opened Clustered Column Chart

Hi ghouse_peer ,

We can use the following steps to meet your requirement.

1. First step is to close the auto date/time function in Data load.

2. Create month column and year column in date table.

Month = MONTH('Date'[Date])
Year = YEAR('Date'[Date])

3. Then we can create two relationships between two tables, the date to open date is active and the date to closed date is inactive.

4. We can create two measures to calculate the open date count and closed date count.

Open = CALCULATE(DISTINCTCOUNT('Table'[Ticket Number]))

Closed = CALCULATE(DISTINCTCOUNT('Table'[Ticket Number]),USERELATIONSHIP('Date'[Date],'Table'[Ticket Closed Date]))

Then create a column chart and put them in it, the result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.