Forum Discussion
How to calculate Backlog Tickets
Hey Champs,
I'm new to power BI and trying to find the number of new,closed and Backlog tickets in my data.
Scenario: I have two tables
1. Tickets Data - It has ID, Created date, Solved Date and Status column
I created new tickets from Created date, Closed tickets from solved date
2. Date column created to establish non-active relationship to calculate new and closed tickets.
Below are the measure I have created for new and closed
________________________________________________________________________________
if we are calculating it for month of February then
(the tickets should be created before february) and ((the tickets should not fall in closed, solved or deleted status) OR (solved date should be in february or after))
| From Date table | Measures created | ||||
| Year | Month | New_Tickets | Closed_Tickets | Difference | Backlog Tickets |
| 2022 | August | 4811 | 4783 | 28 | 373 |
| 2022 | September | 4708 | 4759 | -51 | 322 |
| 2022 | October | 4531 | 4509 | 22 | 344 |
| 2022 | November | 4124 | 4137 | -13 | 331 |
| 2022 | December | 4135 | 4101 | 34 | 365 |
| 2023 | January | 4569 | 4518 | 51 | 416 |
pls let meknow if you need any other information
3 Replies
- amitchandak
Super User
ShravanG , seem very similar to HR problem
Power BI: 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-trend/ba-p/882970Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
- Ashish_Mathur
Hi,
Share the raw dataset to work with and show the expected result.
Thank you for the replies, the problem has been solved now.
