Forum Discussion
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,...
Since you want a calculated column, use below.
A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")
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")
Hi
I get errors when using the same DAX
may I know how to edit?
