let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Tên SP", type text}, {"01/04/2024", Int64.Type}, {"02/04/2024", Int64.Type}, {"03/04/2024", Int64.Type}, {"04/04/2024", Int64.Type}, {"05/04/2024", Int64.Type}, {"06/04/2024", Int64.Type}, {"07/04/2024", Int64.Type}, {"08/04/2024", Int64.Type}, {"09/04/2024", Int64.Type}, {"10/04/2024", Int64.Type}, {"11/04/2024", Int64.Type}, {"12/04/2024", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Tên SP"}, "Attribute", "Value"),
#"Grouped Rows" = Table.Group(#"Unpivoted Other Columns", {"Tên SP"}, {{"LanDau", each List.Min([Attribute]), type text}, {"GanNhat", each List.Max([Attribute]), type text}})
in
#"Grouped Rows"