Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to Solution.
This should do the trick:
Measure =
IF(
HASONEVALUE('Table'[Thesaurus term]),
CONCATENATEX('Table','Table'[Final],", ")
)
Proud to be a Super User!
This should do the trick:
Measure =
IF(
HASONEVALUE('Table'[Thesaurus term]),
CONCATENATEX('Table','Table'[Final],", ")
)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |