Grouping strings from duplicate row entries

[MichaelHutchens]

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 term	Final
aging	ageing,ripening,senescence,ageing

Any help would really be appreciated 🙂

[ChrisMendoza · Accepted solution]

This should do the trick:

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

[MichaelHutchens]

Perfect @ChrisMendoza, thank you so much! 🙂