Created, Resolved, and Backlog for Jira Tickets

[iabdul-q]

Hi,

I'm trying to create a column chart that displays tickets created per month, tickets closed and resolved per month, and the backlog as it changes month to month. Backlog would be anything not considered closed or resolved. The problem is I'm using the dates offered by Jira, which are created and resolved date. This isn't giving the most accurate data. The other issue is, as shown on the picture, for backlog change I am calculating the difference between created and resolved tickets to show the change, but I would rather have the change in total backlog. If any more information is required please let me know. 

[iabdul-q]

Still unsure which part exactly would help with my particular issue. Do I just make a date table have relationships between created + resolved date and the date table? Not sure where to go from there

[amitchandak]

@iabdul-q , I think method of deal with Start date and end date should help

HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU