cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngadiez Member
Member

Multi Value in a column

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

1 ACCEPTED SOLUTION

Accepted Solutions
quentin_vigne Senior Member
Senior Member

Re: Multi Value in a column

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

3 REPLIES 3
quentin_vigne Senior Member
Senior Member

Re: Multi Value in a column

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 Member
Member

Re: Multi Value in a column

@quentin_vigne

 

It works. Thank you so much

quentin_vigne Senior Member
Senior Member

Re: Multi Value in a column

@ngadiez

 

You're welcome,

 

Have a good day.

 

- Quentin