Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
3 years ago

Joining Tables - IF statement

I have a user that wants me to join two tables on email, but when it doesn't find any matches to join on phone number.  We can't do anything like that in Power Bi, can we??
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

aashton not unfortunately but what is the end goal?

aashton's avatar
aashton
Icon for Helper V rankHelper V
3 years ago

parry2k I have a table of employee leads met at certain events the company has.  It has basic info; name, email, phone.  We then want to find out if any of these people filled out applications.  The only unique fields on the application we can join on are email or phone number.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI aashton,

    So you mean to display 'Tag' if the current row 'user id' is included in other table and match with conditions? If that is the case, you can add a calculated column at the current table and use it lookup another table records based on current table field values and conditions. 

    Can you please share some dummy data with table format and detailed compare logics to help us clarify your data structure and test coding formula?

    How to Get Your Question Answered Quickly  

    Notice: please not attach sensitive data in your sharing.

    Regards,

    Xiaoxin SHeng

    • aashton's avatar
      aashton
      Icon for Helper V rankHelper V
      2 years ago

      Anonymous Sorry for the late response, I didn't see this reply.  What if I make a copy of the Events table, link the first table to Applications on Email, link the second table to Applications on Phone Number.  Then when creating metrics for Number of Event Leads, Number of Applications.....Count total Applications from Event 1 plus, the number of Applications from Events 2 but only those records where the email does not exist in Event 1?  Is something like that doable?