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.
This is an issue I attempting to solve and haven't been able to find any resources on. I'd like community feedback on how best to solve this scenario.
Scenario: I need a daily count of open IT Tickets 10 days or older. I'm given a unique ticket number, creation date, and resolution date.
Example Table:
TicketNumber | CreationDate | ResolveDate |
45100 | 11/1/2022 | 11/16/2022 |
45145 | 11/2/2022 | 11/11/2022 |
45186 | 11/2/2022 | 11/13/2022 |
45187 | 11/2/2022 | 11/12/2022 |
45227 | 11/3/2022 | 11/11/2022 |
45304 | 11/3/2022 | 11/12/2022 |
45347 | 11/3/2022 | 11/17/2022 |
45378 | 11/3/2022 | 11/13/2022 |
45419 | 11/4/2022 | 11/17/2022 |
45423 | 11/4/2022 | 11/9/2022 |
45497 | 11/4/2022 | 11/9/2022 |
45515 | 11/5/2022 | 11/14/2022 |
45588 | 11/7/2022 | 11/13/2022 |
45600 | 11/8/2022 | 11/17/2022 |
45700 | 11/8/2022 | 11/15/2022 |
45711 | 11/8/2022 | 11/21/2022 |
45716 | 11/9/2022 | 11/19/2022 |
45743 | 11/10/2022 | 11/23/2022 |
45747 | 11/12/2022 | 11/17/2022 |
45785 | 11/13/2022 | 11/28/2022 |
45797 | 11/13/2022 | 11/25/2022 |
45804 | 11/13/2022 | 11/24/2022 |
45849 | 11/15/2022 | 11/24/2022 |
45869 | 11/16/2022 | 11/29/2022 |
45939 | 11/17/2022 | 11/25/2022 |
45980 | 11/19/2022 | 12/3/2022 |
45983 | 11/19/2022 | 11/28/2022 |
45984 | 11/20/2022 | 12/2/2022 |
45990 | 11/20/2022 | 11/26/2022 |
Expected Result:
AgedTicket_Ct | Date |
0 | 11/1/2022 |
0 | 11/2/2022 |
0 | 11/3/2022 |
0 | 11/4/2022 |
0 | 11/5/2022 |
0 | 11/6/2022 |
0 | 11/7/2022 |
0 | 11/8/2022 |
0 | 11/9/2022 |
0 | 11/10/2022 |
1 | 11/11/2022 |
2 | 11/12/2022 |
3 | 11/13/2022 |
3 | 11/14/2022 |
3 | 11/15/2022 |
3 | 11/16/2022 |
2 | 11/17/2022 |
1 | 11/18/2022 |
1 | 11/19/2022 |
2 | 11/20/2022 |
2 | 11/21/2022 |
1 | 11/22/2022 |
4 | 11/23/2022 |
3 | 11/24/2022 |
2 | 11/25/2022 |
2 | 11/26/2022 |
2 | 11/27/2022 |
2 | 11/28/2022 |
2 | 11/29/2022 |
2 | 11/30/2022 |
2 | 12/1/2022 |
2 | 12/2/2022 |
1 | 12/3/2022 |
Solved! Go to Solution.
@Almercie , Please check the single-age bucket page in the attached file. This is on HR data, but it will work the same in your case
@Almercie , Please check the single-age bucket page in the attached file. This is on HR data, but it will work the same in your case
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |