topic Re: compare two columns in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027636#M103301 <P>Hii&nbsp;Anonymous</LI-USER>&nbsp;,<BR />Can you please try following measure:</P><P><img /></P><P>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.</P> Wed, 18 Jan 2023 05:56:18 GMT KeyurPatel14 2023-01-18T05:56:18Z compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027622#M103300 <P>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;</P><P>&nbsp;</P><DIV><DIV><SPAN>True/False = </SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; 'Global POL'[CBL]= 'Global POL'[CBL Local],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"True"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;</SPAN><SPAN>"False"</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P>INPUT :</P><P>&nbsp;</P><P>&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;</P><P>&nbsp; 122&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002</P><P>&nbsp; 123&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS004&nbsp;</P><P>&nbsp; 124&nbsp; &nbsp; &nbsp; &nbsp; MS14-CA04CAS004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MS14-CA04CAS002&nbsp;</P><P>&nbsp; 125</P><P>&nbsp;</P><P>EXPECTED OUTPUT:</P><P>&nbsp;</P><P>&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</P><P>&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;</P><P>&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;</P><P>&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</P><P>&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</P> Wed, 18 Jan 2023 05:56:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027622#M103300 Anonymous 2023-01-18T05:56:54Z Re: compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027636#M103301 <P>Hii&nbsp;Anonymous</LI-USER>&nbsp;,<BR />Can you please try following measure:</P><P><img /></P><P>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.</P> Wed, 18 Jan 2023 05:56:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027636#M103301 KeyurPatel14 2023-01-18T05:56:18Z Re: compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027641#M103303 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="493162" data-lia-user-login="KeyurPatel14" class="lia-mention lia-mention-user">KeyurPatel14</a>&nbsp; if both column blank its also False&nbsp;</P> Wed, 18 Jan 2023 05:57:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027641#M103303 Anonymous 2023-01-18T05:57:38Z Re: compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027694#M103308 <P>Hii&nbsp;Anonymous</a>&nbsp;,<BR />Please try below formula:</P><P><img /></P><P>&nbsp;</P> Wed, 18 Jan 2023 06:14:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027694#M103308 KeyurPatel14 2023-01-18T06:14:56Z Re: compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027710#M103311 <P>Hii&nbsp;Anonymous</a>&nbsp;,<BR />Please enter below formula:</P><P><img /></P><P>&nbsp;</P> Wed, 18 Jan 2023 06:18:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027710#M103311 KeyurPatel14 2023-01-18T06:18:32Z Re: compare two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027719#M103312 <P><img /></P><DIV><DIV><SPAN>Compare = </SPAN></DIV><DIV><SPAN>&nbsp;</SPAN><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>Compare</SPAN><SPAN>[CBL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;]</SPAN><SPAN>=</SPAN><SPAN>Compare</SPAN><SPAN>[Column1]</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>AND</SPAN><SPAN>(</SPAN><SPAN>Compare</SPAN><SPAN>[CBL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() , </SPAN><SPAN>Compare</SPAN><SPAN>[Column1]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>()),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"True"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;</SPAN><SPAN>"False"</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P> Wed, 18 Jan 2023 06:23:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/compare-two-columns/m-p/3027719#M103312 Mahesh0016 2023-01-18T06:23:27Z