这适用于任意数量的列和行。
let Filter="a",
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Columns = Table.ColumnNames(Source),
#"Added Index1" = Table.AddIndexColumn(Source, "Indexz", 0, 1),
Unpivot = Table.UnpivotOtherColumns(#"Added Index1", {"Indexz"}, "Attribute", "Value"),
Grouped = Table.Group(Unpivot, {"Attribute","Value"}, {{"Count", each Table.AddIndexColumn(_, "Index",1,1), type table}}),
#"Expanded Count" = Table.ExpandTableColumn(Grouped, "Count", {"Indexz", "Index"}, {"Indexz", "Index"}),
#"Added Custom" = Table.AddColumn(#"Expanded Count", "Count", each if [Value]=Filter then [Index] else null),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Value","Index"}),
#"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Attribute]), "Attribute", "Count"),
#"Removed Columns1" = Table.RemoveColumns(#"Pivoted Column",{"Indexz"})
in #"Removed Columns1"
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句