Multi Value in a column

[ngadiez]

Hi I have a table like this

1. ID          Name
2. 1            Pen
3. 2            Chair
4. 2            Table
5. 3            Plug
6. 3            Power
7. 3            shocket

I want to make it to this for my visualisation table

1. ID          Name
2. 1            Pen
3. 2            Chair, Table
4. 3            Plug, Power, shocket

Is there any way to do this?

I saw from other forum is using = CONCATENATEX ( FILTER ( VALUES (Table[Name])  ), Table[Name], ", ")

However it doesnt work for same table. only work for diferent table.

Any idea how to do this? All the master

@Greg_Deckler, @MattAllington @Phil_Seamark @quentin_vigne

[quentin_vigne · Accepted solution]

Hi @ngadiez

You were almost there, here what I would do as your table is ordered on ID

Grouped_Name = CONCATENATEX(FILTER(ALL('Table1');[ID]=EARLIER('Table1'[ID]));[Name];", ")

You may need to change ";" to "," as I'm using french version of PowerBI (depending of your version)

Have a good day

- Quentin

[ngadiez]

@quentin_vigne

It works. Thank you so much

[quentin_vigne]

@ngadiez

You're welcome,

Have a good day.

- Quentin