Power Query -->Group By --> Advanced --> All Rows

[lezawang]

Hello all

I am trying to understand Group by --> All Rows option. I have 3 tables and I Appended them and then Grouped By --> All Row and then Expanded to include Jan, Feb and Mar and then ended with a table like below. I do not see a need to do the "All Rows". I could have sorted and get the same result, or am I wrong? Thank you very much for your help.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	item	jan	feb	mar
2	A	1	1	1			item	All.jan	All.feb	All.mar
3	B	1	1	1			A	1	1	1
4	C	1	1	1			A	2	2	2
5							A	3	3	3
6							B	1	1	1
7	item	jan	feb	mar			B	2	2	2
8	A	2	2	2			B	3	3	3
9	B	2	2	2			C	1	1	1
10	C	2	2	2			C	2	2	2
11							C	3	3	3
12							D	3	3	3
13	item	jan	feb	mar
14	A	3	3	3
15	B	3	3	3
16	C	3	3	3
17	D	3	3	3
18
Sheet1

 

[alansidman]

All rows becomes handy if you are doing multiple group bys. You may group by another factor and have it show all rows also. On a stand alone basis, you are correct.

Look at Example 3 here-->Grouping rows with Power BI / Power Query — The Power User

 

[lezawang]

Thank you for your help.