compare two columns

Question

I have Global POL table, trying to Compare the two column&nbsp; CBL and CBL LOCAL&nbsp; .If both column value same its return&nbsp; true. if values not match and both column blank its return False. i have tired the below measure .&nbsp;&nbsp;True/False = IF (&nbsp; &nbsp; 'Global POL'[CBL]= 'Global POL'[CBL Local],&nbsp; &nbsp; "True",&nbsp; &nbsp;"False"&nbsp; &nbsp; )&nbsp;INPUT :&nbsp;&nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CBL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CBL LOCAL&nbsp;&nbsp; 122&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; 123&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS004&nbsp;&nbsp; 124&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp;&nbsp; 125&nbsp;EXPECTED OUTPUT:&nbsp;&nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CBL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CBL LOCAL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TRUE/FALSE&nbsp; 122&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE&nbsp;&nbsp; 123&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TRUE&nbsp;&nbsp; 124&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FALSE&nbsp; 125&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FALSE

mahesh0016 · Answer

Compare = &nbsp;IF (&nbsp; &nbsp; Compare[CBL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;]=Compare[Column1] &amp;&amp; AND(Compare[CBL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;]&lt;&gt;BLANK() , Compare[Column1]&lt;&gt;BLANK()),&nbsp; &nbsp; "True",&nbsp; &nbsp;"False"&nbsp; &nbsp;)&nbsp;

keyurpatel14 · Answer

Hii&nbsp;Anonymous&nbsp;,Please try below formula:&nbsp;

keyurpatel14 · Answer

Hii&nbsp;Anonymous&nbsp;,Please enter below formula:&nbsp;

keyurpatel14 · Answer

Hii&nbsp;Anonymous&nbsp;,Can you please try following measure:I have taken this as a sample data so apply this formula to your data and if this helps you then accpet this as a solution and give a thumbs up.

anonymous · Answer

KeyurPatel14&nbsp; if both column blank its also False&nbsp;

Forum Discussion

compare two columns

5 Replies

Related content

Compare Dynamic Columns in a Matrix

Compare two columns in different tables

Comparing columns error

Comparing two tables columns by columns

Table Sort , sort order , comparer