PQ
- let
- Source = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
- Custom1 = Table.Group(Source,"销售单号",{"n",each [ a=List.Count(List.Distinct([商品名称]))>2,
- b=List.Count(List.Distinct([三级分类码]))>2,
- c=Table.RowCount(Table.SelectRows(_,(x)=>x[毛利率区分]="<=10%"))>0,
- d=Table.RowCount(Table.SelectRows(_,(x)=>x[销售单价]<10))>0,
- e=List.ContainsAny([经营属性],{"核心战略","核心主推","普通高毛"}),
- f=a and b and c and d and e
- ][f]}),
- #"Filtered Rows" = Table.SelectRows(Custom1, each ([n] = true)),
- #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"n"})
- in
- #"Removed Columns"
复制代码
|