https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-DAX/m-p/696316#M698 <P>Someone help me convert the SQL below to DAX?</P><P>&nbsp;</P><DIV><DIV><SPAN>SELECT</SPAN><SPAN> FB.MONTH, </SPAN><SPAN>COUNT</SPAN><SPAN>(QTD)</SPAN></DIV><DIV><SPAN>from</SPAN><SPAN> FACT_BEN FB</SPAN></DIV><DIV><SPAN>INNER JOIN</SPAN><SPAN> DIM_BEN DB </SPAN><SPAN>ON</SPAN><SPAN> FB.BEN_SK </SPAN><SPAN>=</SPAN><SPAN> DB.BEN_SK</SPAN></DIV><DIV><SPAN>AND</SPAN><SPAN> DB.STATUS </SPAN><SPAN>=</SPAN> <SPAN>'A'</SPAN></DIV><DIV><SPAN>AND</SPAN><SPAN> FB.MONTH </SPAN><SPAN>&gt;=</SPAN><SPAN>'201901'</SPAN></DIV><DIV><SPAN>GROUP BY</SPAN><SPAN> FB.MONTH</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>thanks! Norberto</SPAN></DIV><DIV>&nbsp;</DIV></DIV> Tue, 21 May 2019 19:25:04 GMT Anonymous 2019-05-21T19:25:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-DAX/m-p/696316#M698 <P>Someone help me convert the SQL below to DAX?</P><P>&nbsp;</P><DIV><DIV><SPAN>SELECT</SPAN><SPAN> FB.MONTH, </SPAN><SPAN>COUNT</SPAN><SPAN>(QTD)</SPAN></DIV><DIV><SPAN>from</SPAN><SPAN> FACT_BEN FB</SPAN></DIV><DIV><SPAN>INNER JOIN</SPAN><SPAN> DIM_BEN DB </SPAN><SPAN>ON</SPAN><SPAN> FB.BEN_SK </SPAN><SPAN>=</SPAN><SPAN> DB.BEN_SK</SPAN></DIV><DIV><SPAN>AND</SPAN><SPAN> DB.STATUS </SPAN><SPAN>=</SPAN> <SPAN>'A'</SPAN></DIV><DIV><SPAN>AND</SPAN><SPAN> FB.MONTH </SPAN><SPAN>&gt;=</SPAN><SPAN>'201901'</SPAN></DIV><DIV><SPAN>GROUP BY</SPAN><SPAN> FB.MONTH</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>thanks! Norberto</SPAN></DIV><DIV>&nbsp;</DIV></DIV> Tue, 21 May 2019 19:25:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-DAX/m-p/696316#M698 Anonymous 2019-05-21T19:25:04Z