Forum Discussion
Using Concatenate, Merge or Combine multiple rows into one value
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 ...
Anonymous
You can place [Parent] column from table2 in table visual along with the following measure
Items = CONCATENATEX ( VALUES ( table1[Item] ), table1[Item], ", " )
Hi Anonymous
Can you please clarify what exactly you mean by "move over"?
sure I did RELATED(table2[parent]) to put the parent names on to table 1.
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?I would like table visual please.