I won’t add my PBIX file for this one as it’s more of a logical question that I am hoping for some help with please
I am looking at data from a ticketing system, within this I have a ticket created date and ticket completed date
I also have a date table.
I understand that I can create active and inactive relationships between both of the ticket date values, and connect these to the date table.
My question is, if I want to create a bar chart showing my total tickets created each month, and total tickets closed each month (irrespective of when they were created), what should I use as my X-Axis?
My concern is that if X-Axis uses the Month column from my date table, it will be referencing the active relationship, meaning if I have an active relationship between the date table and ticket completed date, it would only show me the created tickets which were also completed in that month, which would be the incorrect data.
Or, should both my date relationships be inactive and I USERELATIONSHIP and create some sort of measure?
Or is it something else and am I missing something really obvious?
I hope this makes sense, however happy to provide additional clarification if necessary.