How to count tickets opened and closed on the same graph

msbutton27 it is pretty straightforward, add a date dimension to your model, see these videos on how to do it, and change the type "create date" and "close date" columns to type date in PQ.

Set the relationship of these two dates with the date dimension on the date column, one relationship will be active, other will be inactive. Assume create date relationship is active, add the following two measures, and in visuals, use year and month from the date dimension and the measures on the values:

Learn basics of Time Intelligence DAX functions - Part 1 - YouTube

Learn why marking a Date dimension as date table is critical to use DAX Time Intelligence functions - YouTube

Create Count = COUNTROWS ( YourTable )

Closed Count = CALCULATE ( [Create Count], USERELATIONSHIP ( YourTable[Closed Date], DateTable[Date] ) )

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️