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")

Anonymous's avatar
Anonymous
Not applicable
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")