Forum Discussion

Sbish's avatar
Sbish
New Member
2 years ago
Solved

Singular and double CONTAINSSTRING terms

I have a dataset with strength descriptors in a column which resembles the following;

 

Row 1: extremely weak

Row 2: very weak

Row 3: very weak to weak

Row 4: weak

 

I think I'm relatively happy how to use CONTAINSSTRING() as a custom column in order to identify double word strings like 'very weak' (which should return TRUE for Row 2 and Row 3 for example).

 

I've also been trying to think of a way to use CONTAINSSTRING() to return TRUE for just the term 'weak' (i.e. False (Row 1), False (Row 2), True (Row 3), True (Row 4)) but I'm struggling to think of the best way to achieve this? I was thinking of filtering out 'very weak' first, but that would mean filtering out Row 3 which also contains the singular 'weak' term. 

 

There might be a simple solution, but my brain is struggling with the logic. 

 

2 Replies

  • Weird to manipulate strings with DAX given that its biggest strength lies in filtering/aggregation. Do it in Power Query, if possible.