Forum Discussion

ngadiez's avatar
ngadiez
Icon for Helper II rankHelper II
8 years ago
Solved

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 fo...
Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    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

quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

ngadiez

 

You're welcome,

 

Have a good day.

 

- Quentin