topic Going Crazy with a stupid thing for sure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956053#M153554 <P>Hi all<BR /><BR /></P><P>I am new in power bi and using it for a couple of weeks and learning with google and youtube <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>Can anyone help me as i have an error : 'The syntax for ',' is incorrect. (DAX( IF(.....'</P><P>the comands are very basic and i use them for a new colum:</P><P>&nbsp;</P><DIV><DIV><SPAN>Robot_TtF =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AND</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Title]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[RepairType]</SPAN><SPAN>=</SPAN><SPAN>"In House"</SPAN><SPAN> ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>OR</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Status]</SPAN><SPAN>=</SPAN><SPAN>"Closed"</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Status]</SPAN><SPAN>=</SPAN><SPAN>"Shipped to Customer"</SPAN><SPAN> ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AND</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>blank</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>DAY</SPAN><SPAN>) ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>=</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>1000</SPAN><SPAN> ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>=</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>2000</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>TODAY</SPAN><SPAN>() , </SPAN><SPAN>DAY</SPAN><SPAN>) ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>4000</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>5000</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can any one help me and see were the error is as i am not.<BR />Thanks</SPAN></DIV></DIV> Tue, 28 May 2024 23:31:24 GMT Orlando_Tuga 2024-05-28T23:31:24Z Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956053#M153554 <P>Hi all<BR /><BR /></P><P>I am new in power bi and using it for a couple of weeks and learning with google and youtube <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>Can anyone help me as i have an error : 'The syntax for ',' is incorrect. (DAX( IF(.....'</P><P>the comands are very basic and i use them for a new colum:</P><P>&nbsp;</P><DIV><DIV><SPAN>Robot_TtF =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AND</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Title]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[RepairType]</SPAN><SPAN>=</SPAN><SPAN>"In House"</SPAN><SPAN> ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>OR</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Status]</SPAN><SPAN>=</SPAN><SPAN>"Closed"</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[Status]</SPAN><SPAN>=</SPAN><SPAN>"Shipped to Customer"</SPAN><SPAN> ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>AND</SPAN><SPAN>( </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>blank</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>DAY</SPAN><SPAN>) ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>=</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>1000</SPAN><SPAN> ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateShipped]</SPAN><SPAN>=</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>2000</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>&lt;&gt;</SPAN><SPAN>BLANK</SPAN><SPAN>() ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>EPCC_Cases</SPAN><SPAN>[DateReceivedAtEPCC]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN> , </SPAN><SPAN>TODAY</SPAN><SPAN>() , </SPAN><SPAN>DAY</SPAN><SPAN>) ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>4000</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ) ,</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>5000</SPAN></DIV><BR /><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can any one help me and see were the error is as i am not.<BR />Thanks</SPAN></DIV></DIV> Tue, 28 May 2024 23:31:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956053#M153554 Orlando_Tuga 2024-05-28T23:31:24Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956488#M153567 <P>Hi,</P> <P>If your setting shows "," as error, please try ";"&nbsp;</P> <P>&nbsp;</P> Wed, 29 May 2024 04:11:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956488#M153567 Jihwan_Kim 2024-05-29T04:11:19Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956694#M153573 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="751107" data-lia-user-login="Orlando_Tuga" class="lia-mention lia-mention-user">Orlando_Tuga</a>&nbsp;,</P> <P>&nbsp;</P> <P>Try using the following expression:</P> <LI-CODE lang="markup">Robot_TtF = IF( AND(EPCC_Cases[Title] &lt;&gt; BLANK(), EPCC_Cases[RepairType] = "In House"), IF( OR(EPCC_Cases[Status] = "Closed", EPCC_Cases[Status] = "Shipped to Customer"), IF( AND(EPCC_Cases[DateReceivedAtEPCC] &lt;&gt; BLANK(), EPCC_Cases[DateShipped] &lt;&gt; BLANK()), DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], EPCC_Cases[DateShipped], DAY), IF( EPCC_Cases[DateReceivedAtEPCC] = BLANK(), 1000, IF( EPCC_Cases[DateShipped] = BLANK(), 2000 ) ) ), IF( EPCC_Cases[DateReceivedAtEPCC] &lt;&gt; BLANK(), DATEDIFF(EPCC_Cases[DateReceivedAtEPCC], TODAY(), DAY), 4000 ) ), 5000 )</LI-CODE> <P>&nbsp;</P> <P><SPAN>Hope it helps!</SPAN></P> <P>&nbsp;</P> <P>Best regards,<BR />Community Support Team_ Scott Chang</P> <P>&nbsp;</P> <P>If this post helps then please consider&nbsp;<STRONG>Accept it as the solution</STRONG>&nbsp;to help the other members find it more quickly.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 29 May 2024 06:00:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956694#M153573 Anonymous 2024-05-29T06:00:52Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956794#M153575 <P>Tried it and does not work.</P><P>&nbsp;</P> Wed, 29 May 2024 06:28:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956794#M153575 Orlando_Tuga 2024-05-29T06:28:56Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956814#M153576 <P>It worked, was it due to the spaces?</P> Wed, 29 May 2024 06:35:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956814#M153576 Orlando_Tuga 2024-05-29T06:35:02Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956817#M153577 <P>Thanks</P> Wed, 29 May 2024 06:35:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956817#M153577 Orlando_Tuga 2024-05-29T06:35:35Z Re: Going Crazy with a stupid thing for sure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956856#M153578 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="751107" data-lia-user-login="Orlando_Tuga" class="lia-mention lia-mention-user">Orlando_Tuga</a>&nbsp;,</P> <P>&nbsp;</P> <P>The main reason is the Date.</P> <P>&nbsp;</P> <P>Best regards,<BR />Community Support Team_ Scott Chang</P> Wed, 29 May 2024 06:52:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Going-Crazy-with-a-stupid-thing-for-sure/m-p/3956856#M153578 Anonymous 2024-05-29T06:52:21Z