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.
Ashish_Mathur
Super User
Super UserHi,
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.
Ashish_Mathur Thank you ! worked😀
- Ashish_Mathur
You are welcome.