Forum Discussion

Arial12's avatar
Arial12
Frequent Visitor
7 years ago

Case like statements - Compare two table columns

Hi Experts,   I have two table with similar column that i want to compare and calculate a column.   something like this,   if tabl1.col1 = tabl2.col1 then "yes" else "NO"   any suggestion?  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Merge the tables into a new one in Power Query, then you can easily achieve what you want.

  • Arial12's avatar
    Arial12
    Frequent Visitor
    7 years ago

    can't merge them. both are very large tables

    • Christann's avatar
      Christann
      Advocate IV
      7 years ago

      Try creating a relationship between the tables and then use a function like:

      isequal = IF(Table[Column1]=RELATED(Table2[Column1]),"yes","no")

      Hope this helps!

      • Arial12's avatar
        Arial12
        Frequent Visitor
        7 years ago

        Tables don't have a relationship.