Forum Discussion
ngadiez
8 years agoHelper II
Multi Value in a column
Hi I have a table like this
- ID Name
- 1 Pen
- 2 Chair
- 2 Table
- 3 Plug
- 3 Power
- 3 shocket
I want to make it to this for my visualisation table
- ID Name
- 1 Pen
- 2 Chair, Table
- 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
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
- quentin_vigneSolution Sage
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
- ngadiezHelper II
- quentin_vigneSolution Sage