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.
Hi Everyone,
I have data something like this, and I want to count no days in the queue, group by Incident Number and status.
Available Data:
Ticket Number | Start date | End date | Days in Queue | Status | Queue |
12124 | 4/12/2022 | 4/13/2022 | 1 | Closed | Tier3 |
12124 | 4/13/2022 | 4/15/2022 | 2 | Closed | Tier3 |
12121 | 4/15/2022 | 4/16/2022 | 1 | Closed | Tier3 |
12122 | 4/16/2022 | 4/17/2022 | 1 | Closed | Tier3 |
12124 | 4/16/2022 | 4/18/2022 | 2 | Closed | Tier3 |
Required Output:
Ticket Number | Days in Queue | Status | Queue |
12124 | 5 | Closed | Tier3 |
12121 | 1 | Closed | Tier3 |
12122 | 1 | Closed | Tier3 |
Solved! Go to Solution.
Hi @Shree_185 ,
You can directly drag your required field and mark ticket number column as dont summerize and mark days column summerized as sum.
And if you need a separate table then you could use below code:-
Table 2 = SUMMARIZE('Table','Table'[Ticket Number],'Table'[Queue],'Table'[Status ],"Number of Days",SUM('Table'[Days in Queue]))
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Shree_185 ,
You can directly drag your required field and mark ticket number column as dont summerize and mark days column summerized as sum.
And if you need a separate table then you could use below code:-
Table 2 = SUMMARIZE('Table','Table'[Ticket Number],'Table'[Queue],'Table'[Status ],"Number of Days",SUM('Table'[Days in Queue]))
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |