Forum Discussion

aashton's avatar
aashton
Helper 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
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
Helper 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?