Forum Discussion

Resolver I

9 years ago

Solved

Concatenate Columns If Same ID

I have a table with rows for item ID, catalog name, and catalog year. Some items are released in multiple catalogs so they have multiple rows. I am trying to create a new measure that will concatenat...

Need Help

Anonymous

Not applicable

9 years ago

Hi khappersett,

I think you need to filter the records which has the same id, then use this as the source of concatenate function.

All Year = CONCATENATEX(FILTER(ALL('sample'),[Item ID]=EARLIER('sample'[Item ID])),[Catalog Year],",")

Regards,

Xiaoxin Sheng

P3Tom

Helper I

9 years ago

Although this topic is titled, "Concatenate Columns If Same ID", later in the original request it says:

"Ultimately, I am trying to find a way to count the items that are in a catalog for one year, but not another."

Restated, concatenation was a means used to count the items that are in a catalog only for one year, but not another.

A complete solution will also give an answer to the ultimate end (what is the count of catalog items that were listed for only one year).

Tom