https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-error-New-in-dax-Using-a-variable/m-p/2394770#M62427 <DIV><DIV><SPAN>FINAL DEPARTMENT = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>D</SPAN><SPAN> = </SPAN><SPAN>RELATED</SPAN><SPAN>(</SPAN><SPAN>'TABLE'[COLUMN]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>NOT</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>D</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>D,</SPAN></DIV><DIV><SPAN>[COLUMN2]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can someone show me why I am getting a syntax error I am new in using DAX so cannot spot it thanks.</SPAN></DIV></DIV> Tue, 15 Mar 2022 09:49:23 GMT akhaliq7 2022-03-15T09:49:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-error-New-in-dax-Using-a-variable/m-p/2394770#M62427 <DIV><DIV><SPAN>FINAL DEPARTMENT = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>D</SPAN><SPAN> = </SPAN><SPAN>RELATED</SPAN><SPAN>(</SPAN><SPAN>'TABLE'[COLUMN]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>NOT</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>D</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>D,</SPAN></DIV><DIV><SPAN>[COLUMN2]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can someone show me why I am getting a syntax error I am new in using DAX so cannot spot it thanks.</SPAN></DIV></DIV> Tue, 15 Mar 2022 09:49:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-error-New-in-dax-Using-a-variable/m-p/2394770#M62427 akhaliq7 2022-03-15T09:49:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-error-New-in-dax-Using-a-variable/m-p/2394830#M62430 <P>I'll answer my own question, you have to use a return keyword before the if statement</P> Tue, 15 Mar 2022 09:52:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-error-New-in-dax-Using-a-variable/m-p/2394830#M62430 akhaliq7 2022-03-15T09:52:25Z