Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do you create a Conditional Column from 2 tables ?

I need to compare email addresses.   If Table "serial" (email address) is different from Table "Monthly Billing" (email address), display Yes If Table "serial" (email address) is the same as Table...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    RESOLVED:

     

    Mismatch = if(MAXX(FILTER('Monthly Billing','Monthly Billing'[Tangoe Owner Email]='users'[Intune Owner Email]),'Monthly Billing'[Tangoe Owner Email])=users[Intune Owner Email],"NO","Yes")

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

In which of the 2 tables do you want to write the calculated column formula?  Of the 2 tables which table has each e-mail listed only once (no repetitions).  It is best to share the link from where i can download your PBI file.