Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 |
Thank you for the replies, the problem has been solved now.
Hi,
Share the raw dataset to work with and show the expected result.
@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-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |