Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Helper V
5 years ago
Solved

Grouping strings from duplicate row entries

Hi everyone, I'm hoping someone can help 🙂

I'm attempting to match a list of terms ('Thesaurus term" column) with synonyms ("Final" column). I have my terms and my list of synonyms, but some of the terms are duplicated over more than one row. I'd like to create another column (I can't use power query for this, FYI) or a calculated table that groups all related synonyms into one line for each unique term. Here's my table of data:


And here's an example of what I'd like to see, using the 'aging' term:

Thesaurus termFinal
agingageing,ripening,senescence,ageing


Any help would really be appreciated 🙂

Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    This should do the trick:

    Measure = 
IF(
    HASONEVALUE('Table'[Thesaurus term]),
    CONCATENATEX('Table','Table'[Final],", ")
)

2 Replies