Forum Discussion

afkl99's avatar
afkl99
Frequent Visitor
8 years ago
Solved

Difference between two text columns

I have two text columns (column A in data table A and column B in data table B -both data tables have id columns).    I want to create a table\matrix in the desktop page that contains an id column,...
Need Help
  • dilumd's avatar
    dilumd
    8 years ago

    Since you want a calculated column, use below.

     

    A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")

dilumd's avatar
dilumd
Impactful Individual
8 years ago

You can relate table A and B first. Then write a IF function to return "yes" if column A1 = column B1 I don't think you need to merge.