Forum Discussion

Helper I

3 years ago

Solved

Compare text string between two tables (Not exact)

I have columns in seperate tables and I need to identify if there is match between the columns. The text in table 1 will be exact where as the text in table 2 may contain the text from table 1 amongs...

Need Help

Anonymous

3 years ago

Hi TIGER8855 ,

You can create a calculated column as below in 'Table 1', please find the details in the attachment.

Column =
VAR _t2col =
    CALCULATE (
        MAX ( 'Table 2'[Column1] ),
        FILTER (
            'Table 2',
            IFERROR ( SEARCH ( 'Table 1'[Column1], 'Table 2'[Column1], 1, 0 ), 0 ) > 0
        )
    )
RETURN
    IF ( ISBLANK ( _t2col ), "No", "Yes" )

Best Regards

Compare text string between two tables.pbix27 KB

Anonymous

Not applicable

3 years ago

Hi TIGER8855 ,

You can create a calculated column as below similar to the previous one to get it:

Column =
VAR _t2col =
    CALCULATE (
        MAX ( 'Table 2'[Column1] ),
        FILTER (
            'Table 2',
            IFERROR ( SEARCH ( 'Table 1'[Column1], 'Table 2'[Column1], 1, 0 ), 0 ) > 0
                && 'Table 2'[Column 2] = "TRUE"
        )
    )
RETURN
    IF ( ISBLANK ( _t2col ), "No", "Yes" )