Using Concatenate, Merge or Combine multiple rows into one value

[Anonymous]

Please help.... so I have items with simlar names example 100-233-5-A & 100-233-5-B under the same column and I am trying to get them together in one row. They do have the same parent from a diffent table and I just cant get this to work. I did RELATED(table2[parent]) to move over the parent names and for item names it shows up as seprete lines for A & B. I would like to also clarify that they were alays two seprete line but I need them to print as one.

[tamerj1 · Accepted solution]

@Anonymous 

You can place [Parent] column from table2 in table visual along with the following measure 

Items = CONCATENATEX ( VALUES ( table1[Item] ), table1[Item], ", " )

[tamerj1]

Hi @Anonymous 

Can you please clarify what exactly you mean by "move over"?

[Anonymous]

sure I did RELATED(table2[parent]) to put the parent names on to table 1.

[tamerj1]

@Anonymous 

You can only add columns to an existing table. You can't edit or change the structure of an existing table. 
You can achieve your expected result using a table visual or a calculated table. Which option would you go for?

[Anonymous]

I would like table visual please.