Count By Group

[ukantkumar]

Using Upper data I want a lower table in power query

I mean I need, Project id, Count of the total, count of completed and tag as separate Column

pls help me 

[Anonymous]

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"

[ukantkumar]

can I have a snapshot of power query step? or PBIX FILE, please 

[Anonymous · Accepted solution]

@ukantkumar 

Sure thing, here's the file:

https://1drv.ms/u/s!Amqd8ArUSwDS0Q9NzQ1-XUQ6ILQJ