Return label and header for max value
label header 1 header 2 header 3 header 4 header 5 label header Value label 1 1 2 3 4 5label 3 header 4 9label 3 6 7 8 9 0label 5 1 0 3 4 6label 7 2 3 3 4 2
label header 1 header 2 header 3 header 4 header 5 label header Value label 1 1 2 3 4 5label 3 header 4 9label 3 6 7 8 9 0label 7 header 2 9label 5 1 0 3 4 6label 7 2 9 3 4 2
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Unpivot = Table.UnpivotOtherColumns(Source, {"label"}, "Attribute", "Value"), Filter = Table.SelectRows(Unpivot, each ([Value] = List.Max(Unpivot[Value]))), Ren = Table.RenameColumns(Filter,{{"Attribute", "header"}}) in Ren




Bookmarks