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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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
5 years ago

Hi Can you explain what needs to be done if we want to achieve this in a measure instead of column ?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    This is an old post.  Please share some data, explain the business context and show the expected result.