topic Re: The syntax error in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274670#M169588 <P>You are missing the RETURN statement.</P> Thu, 07 Nov 2024 21:34:49 GMT lbendlin 2024-11-07T21:34:49Z The syntax error https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274591#M169584 <P><img /></P><P>Please tell me what i am doing wrong. Thank you.</P><P>&nbsp;</P><DIV><DIV><SPAN>SchKPI = </SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN> DaysUntil = </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>today</SPAN><SPAN>(), msdyn_projecttask[Finish], DAY)</SPAN></DIV><BR /><DIV><SPAN>VAR</SPAN><SPAN> ScheduleStatus = </SPAN><SPAN>SWITCH</SPAN><SPAN>(</SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>(msdyn_projecttask[% Complete]&lt;</SPAN><SPAN>100</SPAN><SPAN> &amp;&amp; DaysUntil &lt; </SPAN><SPAN>0</SPAN><SPAN>) || msdyn_projecttask[Finish] &gt; msdyn_projecttask[Baseline Finish], </SPAN><SPAN>"Off Schedule"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>msdyn_projecttask[% Complete]&lt;</SPAN><SPAN>100</SPAN><SPAN> &amp;&amp; DaysUntil &lt; </SPAN><SPAN>45</SPAN><SPAN>, </SPAN><SPAN>"On Watch"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>msdyn_projecttask[Finish] &lt;= msdyn_projecttask[Baseline Finish], </SPAN><SPAN>"On Schedule"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>"Error"</SPAN><SPAN>)</SPAN></DIV></DIV> Thu, 07 Nov 2024 20:00:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274591#M169584 PC2022 2024-11-07T20:00:13Z Re: The syntax error https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274670#M169588 <P>You are missing the RETURN statement.</P> Thu, 07 Nov 2024 21:34:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274670#M169588 lbendlin 2024-11-07T21:34:49Z Re: The syntax error https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274673#M169589 <P>Thank you!</P> Thu, 07 Nov 2024 21:39:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/The-syntax-error/m-p/4274673#M169589 PC2022 2024-11-07T21:39:40Z