Forum Discussion

SteveG_91's avatar
SteveG_91
Helper I
3 years ago
Solved

Compare Two Tables

I have two tables containing application data, Table1 and Table2.  They are related to each other using the common column, APP_NUM.  Table1 has only one row per APP_NUM while Table2 can have 1 or mor...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SteveG_91  ,

    Try this:

    MATCH = CONTAINSSTRING('Table (2)'[PHONE],RELATED('Table'[PHONE_NUM]))

    Output:

     

    Best Regards,

    Yolo Zhu

    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
    3 years ago

    Hi SteveG_91 

     

    You can try this:

    MATCH = IF(ISBLANK(RELATED('Table'[APP_NUM])),FALSE(),CONTAINSSTRING('Table (2)'[PHONE],RELATED('Table'[PHONE_NUM])))

    Best Regards!

     

    Yolo

SteveG_91's avatar
SteveG_91
Helper I
3 years ago

One follow-up question.  In some instances the phone number is missing (null) from Table1 but is on Table2.  The measure is returning True for those.  How can I make it return False?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SteveG_91 

 

You can try this:

MATCH = IF(ISBLANK(RELATED('Table'[APP_NUM])),FALSE(),CONTAINSSTRING('Table (2)'[PHONE],RELATED('Table'[PHONE_NUM])))

Best Regards!

 

Yolo

  • SteveG_91's avatar
    SteveG_91
    Helper I
    3 years ago

    Thanks again, this worked perfectly!