Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compare value in two tables

Hello,   I am trying to compare a single value in two table columns ie. "Table A[values] to Table B[values]" and if they match place a "Yes" in new column or "No" if no match.  My DAX code listed i...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Just in case you want to solve this without creating a relationship between the 2 Tables, write this calculated column in Table2

    Column = if(ISBLANK(LOOKUPVALUE(Table1[Records],Table1[Records],Table2[Received])),"No","Yes")

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you - Dumb Question, what is the benefit of having the relationship between the 2 table in achieving the "Yes" or "No" in the new column?

 

Your help is Much appreciated

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

That allows you to use a RELATED() function.  that formula is much shorter than mine.