powerquery merge ?

[Anonymous]

hello,

sorry if this is too easy question.

I would like to do like following in powerquery.

Is there any way to do this on powerquery? or shoud I do this with dax?

[V-lianl-msft · Accepted solution]

Try :

= Table.Group(#"Changed Type", {"Id"}, {{"List of works", each Text.Combine([Work],", "), type text}})

[Ashish_Mathur · Accepted solution]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Id"}, {{"All Work", each Text.Combine(List.Distinct([Work]), ", "), type text}})
in
    #"Grouped Rows"

Hope this helps.

[Anonymous]

@Ashish_Mathur Thank you ! worked😀

[Ashish_Mathur]

You are welcome.

[V-lianl-msft · Accepted solution]

Try :

= Table.Group(#"Changed Type", {"Id"}, {{"List of works", each Text.Combine([Work],", "), type text}})

[amitchandak]

@Anonymous 

a new meausre concatenatex(distinct(Table[Work]),[Work]) 

a new table

summarize(Table, Table[id],"_work",concatenatex(distinct(Table[Work]),[Work]))

[Anonymous]

@amitchandak 

Thank you for your help!

Is there any way to do this with PowerQuery😅??