Forum Discussion
Solved
Group By dax All rows
Hi! I have a table like the one of the picture, with 17 courses. I'm working with Group By to unify by USERID. After I create that particular table called "NEW" I want to extract the name...
geroagostini , I added two columns to group by and then manually changed the code
Table.Group(Source, {"Category"}, {{"Items", each Text.Combine(List.Sort(List.Distinct([Name])),","), type nullable text}, {"Brands", each Text.Combine(List.Sort(List.Distinct([Brand])),","), type nullable text}})
geroagostini , I added two columns to group by and then manually changed the code
Table.Group(Source, {"Category"}, {{"Items", each Text.Combine(List.Sort(List.Distinct([Name])),","), type nullable text}, {"Brands", each Text.Combine(List.Sort(List.Distinct([Brand])),","), type nullable text}})