PowerQuery ABC Cluster

[Argosch]

Hello everybody,

I have a really tricky question for me, currently I create an ABC analysis (70% of sales I do with X items ...) with Powerpivot. I would like to change this and create the Cluster with Powerquery.
On this Site, i found a solution:

https://www.poweredsolutions.co/2015/06/15/abc-analysis-with-power-query/

but it works only with one parameter - i need 3

Have anyone an Idea?

The tab looks like this:

Item_ID Country Year Sale

The cluster should be calculated using the parameters


Thanks a lot

Argosch

Sorry for my bad english!

 

[horseyride]

Try (a) select the 3 parameter columns (b) right click (c) merge columns (d) using separator like : (e) do ABC on merged column as single parameter (f) split merged column by each occurrence of delimiter to get back to the original three parameters

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
     #"Merged Columns" =  Table.CombineColumns(Table.TransformColumnTypes(Source, {{"Item_ID",  type text}, {"Year Sale", type text}}, "en-US"),{"Item_ID", "Country",  "Year Sale"},Combiner.CombineTextByDelimiter(":",  QuoteStyle.None),"Merged"),
    // do ABC Here
    #"Split Column  by Delimiter" = Table.SplitColumn(#"Merged Columns", "Merged",  Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Merged.1",  "Merged.2", "Merged.3"})
in
    #"Split Column by Delimiter"