Forum Discussion

TeeroyinOttawa's avatar
TeeroyinOttawa
Regular Visitor
5 years ago
Solved

Join on Contains logic

Hi All,  I have what I think is a fairly simple question.  I would like to join two tables based on "contains" logic. So I have Table A and Table B.  Table A has a column Team.   Table B has a colum...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  TeeroyinOttawa  ,
    According to your description, I create this data：

    TableA：

    TableB：

    Here are the steps you can follow：

    1. Create calculated column.

    IF =
IF(
    SUMX('TableB',
    FIND(UPPER('TableA'[column]),
    UPPER('TableB'[column])
    ,,0)
    )>0,"Yes","Not")

    2. Result：

    If the data of table A matches in table B, it is Yes, otherwise it is No

     

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  TeeroyinOttawa  ,
According to your description, I create this data：

TableA：

TableB：

Here are the steps you can follow：

1. Create calculated column.

IF =
IF(
    SUMX('TableB',
    FIND(UPPER('TableA'[column]),
    UPPER('TableB'[column])
    ,,0)
    )>0,"Yes","Not")

2. Result：

If the data of table A matches in table B, it is Yes, otherwise it is No

 

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

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

TeeroyinOttawa's avatar
TeeroyinOttawa
Regular Visitor
5 years ago

Hey Liu,

 

Thanks for this, exactly what I was looking for!  Thanks for helping out a "newbie"

 

Cheers,

Troy