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

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Try these measures

Created = countrows(Data)

Completed count = calculate([Created],Data[completed]<>blank())

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks. but how do i group by teams?