Forum Discussion

ngadiez's avatar
ngadiez
Helper II
8 years ago
Solved

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_DecklerMattAllington Phil_Seamark quentin_vigne

  • 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

  • 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