Forum Discussion
Filtering words using strartwith with DAX
Hello Everyone, I have a column ('ColumnA') containing a string in the format "AAA-word1, AAA-word2, BBB-word3", with varying numbers of words in each entry. My goal is to create a new column ('C...
Hi Anonymous,
You can use the CONTAINSSTRING function to achieve this.
https://learn.microsoft.com/en-us/dax/containsstring-function-dax
Your code can be something like this:
Column B = IF( CONTAINSSTRING([Column A], "AAA"), [Column A] )