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 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.
Anonymous
You can place [Parent] column from table2 in table visual along with the following measure
Items = CONCATENATEX ( VALUES ( table1[Item] ), table1[Item], ", " )
5 Replies
Hi Anonymous
Can you please clarify what exactly you mean by "move over"?
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
You can place [Parent] column from table2 in table visual along with the following measure
Items = CONCATENATEX ( VALUES ( table1[Item] ), table1[Item], ", " )