Forum Discussion

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    let
    Source = Table1,
    #"Grouped Rows" = Table.Group(Source, {"projectID", "tags"}, {{"Total Count", each Table.RowCount(_), type number}, {"Data", each _, type table}}),
    
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Completed Count", 
        each List.Count( 
             List.FindText( [Data][status],"Completed")       
            
            ), Int64.Type
        ),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Data"})
    
in
    #"Removed Columns"