let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Year", Int64.Type}, {"Brand", type text}, {"UOM", type text}, {"Cases", type number}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Brand"}, {{"Max", each List.Max([Cases]), type nullable number}})
in
#"Grouped Rows"