Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

GROUP BY category with not null counts

 I have a table with three columns(Team name, created date, and completed date)   team created completed A 1/1/2022    1/1/2022 A 1/3/2022    null A 1/3/2022    1/3/2022 A 1...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    pls try this

     

    = Table.Group(#"Changed Type", {"team"}, {{"Count", each List.NonNullCount([created]), Int64.Type}, {"Count2", each List.NonNullCount([completed]), Int64.Type}})

     

    pls see the attachment below

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks. Did u do the above code by clicking "Group By" button or just using the code?

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

you can click group by and select count first, then update the formula.