Power Query
1.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Client", Int64.Type}, {"Team", type text}, {"Review Completed", type date}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Client"}),
#"Duplicated Column" = Table.DuplicateColumn(#"Removed Columns", "Review Completed", "Review Completed - Copy"),
#"Inserted Month Name" = Table.AddColumn(#"Duplicated Column", "Month Name", each Date.MonthName([#"Review Completed - Copy"]), type text),
#"Grouped Rows" = Table.Group(#"Inserted Month Name", {"Team", "Month Name"}, {{"Count", each Table.RowCount(_), type number}}),
#"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[#"Month Name"]), "Month Name", "Count")
in
#"Pivoted Column"
2.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Client", Int64.Type}, {"Team", type text}, {"Review Completed", type date}}),
#"Inserted Start of Week" = Table.AddColumn(#"Changed Type", "Start of Week", each Date.StartOfWeek([Review Completed]), type date),
#"Removed Columns" = Table.RemoveColumns(#"Inserted Start of Week",{"Client", "Review Completed"}),
#"Grouped Rows" = Table.Group(#"Removed Columns", {"Team", "Start of Week"}, {{"Count", each Table.RowCount(_), type number}}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Grouped Rows", {{"Start of Week", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Grouped Rows", {{"Start of Week", type text}}, "lt-LT")[#"Start of Week"]), "Start of Week", "Count")
in
#"Pivoted Column"
Bookmarks