Forum Discussion

San_eve's avatar
San_eve
Regular Visitor
3 years ago
Solved

Help with strings

I have two tables. One like below with unique values up to 300 rows. Table 1 xyz abc dce I have another table table 2 with text column like below.   Table 2 xyz_yzx_123 de...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi San_eve ,

     

    Please create a new calculated column:

    Column = 
IF (
    SUMX (
        'Table 1',
        IF (
            SEARCH ( 'Table 1'[Column1], 'Table 2'[Column1], 1, 0 ) > 0,
            1,
            0
        )
    ) > 0,
    "Yes",
    "No"
)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

devanshi's avatar
devanshi
Helper V
3 years ago

Stringcontain =
FILTER(Table2, CONTAINS(Table1, Table1[ColumnName], Table2[ColumnName]))