Grouping columns with conditional agregated function

[Anonymous]

Hi, I have this kind of data and I want to create a grouped table by G1,G2,G3 counting the rows of C column that are distinct from null with power query

G1	G2	G3	K	C
1	1	1	1	null
1	1	1	2	1
2	2	2	3	null
2	2	2	4	1
2	2	2	5	1
3	3	1	6	null
3	3	2	7	1
3	3	3	8	1
3	3	4	9	null

So the result I want to achieve is 

G1	G2	G3	Count
1	1	1	1
2	2	2	2
3	3	1	0
3	3	2	1
3	3	3	1
3	3	4	0

Any help would be appreciated. I was trying to create a function but I can´t figure how to pass the G1, G2, G3 as parameter. Perhaps I need another approach

Thanks,

Julio

[Anonymous]

Thank you @Anonymous 

[Anonymous · Accepted solution]

Hi @Anonymous 

You can directly groupby

Table.Group(yourPreviousStep, {"G1", "G2", "G3"}, {{"Count", each List.NonNullCount(_[C]), Int64.Type}})