Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Grouping columns with conditional agregated function

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    You can directly groupby

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

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Anonymous