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

Anonymous's avatar
Anonymous
Not applicable
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