topic Re: Using Concatenate, Merge or Combine multiple rows into one value in DAX Commands and Tips

Using Concatenate, Merge or Combine multiple rows into one value

Anonymous — Wed, 10 Apr 2024 21:12:42 GMT

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.

Re: Using Concatenate, Merge or Combine multiple rows into one value

tamerj1 — Wed, 10 Apr 2024 21:02:21 GMT

Hi Anonymous

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

Re: Using Concatenate, Merge or Combine multiple rows into one value

Anonymous — Wed, 10 Apr 2024 21:10:59 GMT

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

Re: Using Concatenate, Merge or Combine multiple rows into one value

tamerj1 — Wed, 10 Apr 2024 21:50:19 GMT

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?

Re: Using Concatenate, Merge or Combine multiple rows into one value

Anonymous — Wed, 10 Apr 2024 21:26:45 GMT

I would like table visual please.

Re: Using Concatenate, Merge or Combine multiple rows into one value

tamerj1 — Wed, 10 Apr 2024 21:38:05 GMT

Anonymous

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

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