Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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