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.