Forum Discussion
Solved
Count By Group
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
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"can I have a snapshot of power query step? or PBIX FILE, please
