We often analyse with text values, the DAX text functions will help us analyse these values.
Sometime we may need to do some advanced text comparison or accurately analyse the internal elements (e.g. compare with current and previous record contexts, get the popular items from field values) and the basic DAX text function may not be suitable for these situations.
If you have similar requirement, please check the following scenario.
Sample table with a list of records of users and comments.
#1, List the distinct elements of each user.
We can simple use CONCATENATEX function to merge these comment values. However, the merged results will include the duplicate values.
The basic DAX text functions can be used to do some text comparisons but they are not suitable to handle accurate text element analysis.
For this scenario, you can consider using PATH and GENERATESERIES function to expand a text string to table/list. After these steps, you can compare the detail items easily and accurately in these text strings.