PBI Community Post - Oct 13 2022 - Help with GroupKind.Local MCode.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	If Data in Power Query looks like this before Grouping:
2
3	Personnel ID	Name	Start Date A/A Type	A/A Type
4	587833	ID587833	03/01/2022	VAC
5	587833	ID587833	03/02/2022	VAC
6	587833	ID587833	03/03/2022	VAC
7	587833	ID587833	03/04/2022	DBH
8	587833	ID587833	03/05/2022	MUA
9	587833	ID587833	05/08/2022	SCK
10	587833	ID587833	05/09/2022	VAC
11	587833	ID587833	05/10/2022	TRV
12	587833	ID587833	08/02/2022	VNP
13	587833	ID587833	08/03/2022	MUA
14	587833	ID587833	08/04/2022	VAC
15	587833	ID587833	08/12/2022	MUA
16	888777	ID888777	02/01/2022	MUA
17	888777	ID888777	02/02/2022	MUA
18	888777	ID888777	02/03/2022	MUA
19	888777	ID888777	02/04/2022	REG
20	888777	ID888777	03/15/2022	VAC
21	888777	ID888777	06/02/2022	DBH
22	888777	ID888777	06/03/2022	VAC
23	888777	ID888777	07/11/2022	VAC
24	888777	ID888777	07/12/2022	VAC
25	888777	ID888777	07/13/2022	VAC
26	888777	ID888777	07/14/2022	VAC
27	888777	ID888777	07/15/2022	REG
28
29
30	After Grouping would like the results in Power Query to look like this:				AbsentCode = True if A/AType is: DBH, LNP, MUA, SCK, TRV, VAC, VNP
31
32	AbsentCode	#ofSequencialDays	MUADaysPresent	StartDateOfPeriod	EndDateOfPeriod	Personnel ID	Name	StartDateOfA/AType	A/AType
33	TRUE	4	TRUE	03/01/2022	03/05/2022	587833	ID587833	03/01/2022	VAC
34	TRUE	4	TRUE	03/01/2022	03/05/2022	587833	ID587833	03/02/2022	VAC
35	TRUE	4	TRUE	03/01/2022	03/05/2022	587833	ID587833	03/03/2022	VAC
36	TRUE	4	TRUE	03/01/2022	03/05/2022	587833	ID587833	03/04/2022	DBH
37	TRUE	4	TRUE	03/01/2022	03/05/2022	587833	ID587833	03/05/2022	MUA
38	TRUE	3	FALSE	05/08/2022	05/10/2022	587833	ID587833	05/08/2022	SCK
39	TRUE	3	FALSE	05/08/2022	05/10/2022	587833	ID587833	05/09/2022	VAC
40	TRUE	3	FALSE	05/08/2022	05/10/2022	587833	ID587833	05/10/2022	TRV
41	TRUE	3	TRUE	08/02/2022	08/04/2022	587833	ID587833	08/02/2022	VNP
42	TRUE	3	TRUE	08/02/2022	08/04/2022	587833	ID587833	08/03/2022	MUA
43	TRUE	3	TRUE	08/02/2022	08/04/2022	587833	ID587833	08/04/2022	VAC
44	TRUE	1	TRUE	08/12/2022	08/12/2022	587833	ID587833	08/12/2022	MUA
45	TRUE	3	TRUE	02/01/2022	02/03/2022	888777	ID888777	02/01/2022	MUA
46	TRUE	3	TRUE	02/01/2022	02/03/2022	888777	ID888777	02/02/2022	MUA
47	TRUE	3	TRUE	02/01/2022	02/03/2022	888777	ID888777	02/03/2022	MUA
48	FALSE	1	FALSE	02/04/2022	02/04/2022	888777	ID888777	02/04/2022	REG	<<<<	Wonder if I should just filter these non Absent Code Days out FIRST
49	TRUE	1	FALSE	03/15/2022	03/15/2022	888777	ID888777	03/15/2022	VAC		I only want distinct strings of sequencial Absent Codes
50	TRUE	2	FALSE	06/02/2022	06/03/2022	888777	ID888777	06/02/2022	DBH
51	TRUE	2	FALSE	06/02/2022	06/03/2022	888777	ID888777	06/03/2022	VAC
52	TRUE	4	FALSE	07/11/2022	07/14/2022	888777	ID888777	07/11/2022	VAC
53	TRUE	4	FALSE	07/11/2022	07/14/2022	888777	ID888777	07/12/2022	VAC
54	TRUE	4	FALSE	07/11/2022	07/14/2022	888777	ID888777	07/13/2022	VAC
55	TRUE	4	FALSE	07/11/2022	07/14/2022	888777	ID888777	07/14/2022	VAC
56	FALSE	1	FALSE	07/15/2022	07/15/2022	888777	ID888777	07/15/2022	REG	<<<<
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100