topic Re: Help with strings in DAX Commands and Tips

Help with strings

San_eve — Fri, 23 Jun 2023 10:34:03 GMT

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

def_cba_12

dce_abc_123

abc_11

I need o/p if the column in table 2 contains the strings in table 1. The o/p must be. I can do it with if and or but I have to manually enter 300 values. Hoping there is an easy way. Thanks.

Table 2	O/p
xyz_yzx_123	Yes
def_cba_12	No
dce_abc_123	Yes
abc_11	Yes

Re: Help with strings

devanshi — Fri, 23 Jun 2023 10:58:51 GMT

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

Re: Help with strings

Anonymous — Mon, 26 Jun 2023 03:26:06 GMT

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