Forum Discussion
powerquery merge ?
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?
Try :
= Table.Group(#"Changed Type", {"Id"}, {{"List of works", each Text.Combine([Work],", "), type text}})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.
amitchandak
Super User
Super UserAnonymous
a new meausre concatenatex(distinct(Table[Work]),[Work])
a new table
summarize(Table, Table[id],"_work",concatenatex(distinct(Table[Work]),[Work]))
amitchandak
Thank you for your help!
Is there any way to do this with PowerQuery😅??