duplicated report with Agroup and concatenate column with a common value

[kennylch]

Hi I am using the following link to created a custom column with combine text. 

https://community.fabric.microsoft.com/t5/Desktop/Agroup-and-concatenate-column-with-a-common-value/... 

But how do i skip the duplicated item during the combine, and you can see i have repeated value in my new column

[wdx223_Daniel]

Text.Combine(List.Distinct([ColumnYouWantToCombine]),",")

[kennylch]

Hi. This resolve my issue. But i have a problem. When i distinct on a custom column created in the editor. It gives error. My power editor script as below. I want to use the ORDERNO instead. then error return.

let
Source = Csv.Document(File.Contents("\\sgs-app2\BI-Data\PowerBI\dailyreview.csv"),[Delimiter=";", Columns=103, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Jobs", type text}, {"Level", Int64.Type}, {"CustNo", Int64.Type}, {"Customer", type text}, {"Contract", type text}, {"AC", Int64.Type}, {"ACDesc", type text}, {"PartNo", type text}, {"PartDesc", type text}, {"TOTMat", type number}, {"STDMat", type number}, {"NCMat", type number}, {"OOSMat", type number}, {"TotLabHrs", type number}, {"LDGHrs", type number}, {"COD/HYDHrs", type number}, {"COD/ELEHrs", type number}, {"OOSHrs", type number}, {"BUSHMFGHrs", type number}, {"QRWKHrs", Int64.Type}, {"ACCHrs", Int64.Type}, {"TotLabCost", type number}, {"LDGCost", type number}, {"COD/HYDCost", type number}, {"COD/ELECost", type number}, {"OOSCost", type number}, {"BUSHMFGCost", type number}, {"QRWKCost", Int64.Type}, {"ACCCost", Int64.Type}, {"LHrs1", type number}, {"LHrs2", Int64.Type}, {"LHrs3", type number}, {"LHrs4", type number}, {"LHrs5", type number}, {"LHrs6", type number}, {"LHrs7", type number}, {"LHrs8", type number}, {"LHrs9", Int64.Type}, {"LHrs10", type number}, {"LHrs11", type number}, {"LHrs12", type number}, {"LHrs13", type number}, {"LHrs14", type number}, {"LHrs15", type number}, {"LHrs16", Int64.Type}, {"LHrs17", type number}, {"LCost1", type number}, {"LCost2", Int64.Type}, {"LCost3", type number}, {"LCost4", type number}, {"LCost5", type number}, {"LCost6", type number}, {"LCost7", type number}, {"LCost8", type number}, {"LCost9", Int64.Type}, {"LCost10", type number}, {"LCost11", type number}, {"LCost12", type number}, {"LCost13", type number}, {"LCost14", type number}, {"LCost15", type number}, {"LCost16", Int64.Type}, {"LCost17", type number}, {"Prod Cat", type text}, {"Biz Unit", type text}, {"QTY", Int64.Type}, {"LEG", type text}, {"WorkScope", type text}, {"SubCon", type text}, {"ST", Int64.Type}, {"MUM", type text}, {"AccClosedPer", type text}, {"ProdClosedDate", type date}, {"SerialNo", type text}, {"LHrs18", type number}, {"LHrs19", type number}, {"LCost18", type number}, {"LCost19", type number}, {"S1", type number}, {"S3", type number}, {"S4", type number}, {"S5", type number}, {"S6", type number}, {"S7", Int64.Type}, {"S8", type number}, {"S9", type number}, {"S10", Int64.Type}, {"S11", type number}, {"S12", type number}, {"S13", type number}, {"S14", type number}, {"S15", type number}, {"S16", Int64.Type}, {"S17", type number}, {"S18", Int64.Type}, {"S19", type number}, {"S20", Int64.Type}, {"S21", Int64.Type}, {"S22", Int64.Type}, {"ACCLDGHrs", Int64.Type}, {"ACCVSHHrs", Int64.Type}, {"ACCLDGLCost", Int64.Type}, {"ACCVSHLCost", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "ORDERNO", each Text.Start([Jobs],6)),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"ORDERNO", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Contract"}, {{"ALLJOBS", each Text.Combine(List.Distinct([ORDERNO]),","), type text}})
in
#"Grouped Rows"