Need help in GroupBy for few fields/columns

[Shree_185]

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

[Samarth_18 · Accepted 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