Forum Discussion

geroagostini's avatar
geroagostini
Helper I
3 years ago
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 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]),",")}})

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

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

     

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

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