Group By dax All rows

[geroagostini]

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 names of the Curses of the columns created, remove the duplicates and combine them using some Concatenate function and separatethem without with the comma (",").

 This dax works for the first column. I NEED HELP TO ADD THE REST OF THE COLUMNS (Course 2, Course 3, Course 4,...) in the same concatenated Column "NEW"

= Table.Group(#"Columnas quitadas", {"USERID"},
{
{"NEW", each Text.Combine(List.Distinct(_[Course 1]),",")}})

[amitchandak · Accepted solution]

@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}})