Forum Discussion

Wahid777's avatar
Wahid777
Frequent Visitor
6 years ago
Solved

Creating a conditional column with boolean (Yes/No) result for matching partial text matches

Hi   I've got a column listed as below and I'm trying to create a new column (with a Yes/No or True/False response) if some matches of certain keywords are found in the original column. Would "CONT...
Need Help
Tips and Tricks
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Wahid777  You can use CONTAINSSTRING:

    Column =
CONTAINSSTRING ( Wahid[Original column], "Ambassador" )
    || CONTAINSSTRING ( Wahid[Original column], "CEO" )
    || CONTAINSSTRING ( Wahid[Original column], "Chief Executive Officer" )
    || CONTAINSSTRING ( Wahid[Original column], "Chief Financial Officer" )
    || CONTAINSSTRING ( Wahid[Original column], "CFO" )

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Wahid777 ,

 

You could refer to Finding if a value in table 1 has a matching value in table 2.
You need a Keywords table by entering and there is no relationship between two tables.

Column 3 = 
IF (
    SUMX (
        'Keywords',
        FIND ( UPPER ( 'Keywords'[Keywords] ), UPPER ( [Original column] ),, 0 )
    ) > 0,
    "True",
    "False"
)

 

You can check more details from here.


Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.