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], ", " )
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.