Forum Discussion
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, column A, column B and then another column which indicates if A is the same as B.
I would like to avoid doing a query where I merge column A and B based on the id column, but will if there are no other viable options
Thank you!
Since you want a calculated column, use below.
A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")
4 Replies
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.
Thank you!
When trying to implement the following statement:
IF( EXACT( 'Table A'[A1]), 'Table B'[B1])), "yes", "no")
I get the error: A single value for column 'A1' in table 'Table A' cannot be determined. (for both tables)
It is my understanding that I need to add something in the statement so that column A1 and B1 are only compared when the id column in both tables are equal. Is this correct and how would I go about doing this?
Since you want a calculated column, use below.
A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")
