https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1021249#M13217 The most precise answer is: IT DEPENDS.<BR /><BR />Best<BR />D Sun, 12 Apr 2020 12:08:15 GMT Anonymous 2020-04-12T12:08:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1016049#M13066 <P>Hello everyone!</P><P>&nbsp;</P><P>How do I translate this SQL query into DAX?</P><P>status=0 AND transaction_type_uid=0 AND free_flag IN (0,2)<BR />AND NOT EXISTS (<BR />SELECT 1 FROM cancel_request WHERE user_uid=l.user_uid AND status='pending' AND type IS NULL<BR />)</P><P>&nbsp;</P><P>Thanks in advance!</P> Wed, 08 Apr 2020 20:14:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1016049#M13066 asantarsiero 2020-04-08T20:14:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1016096#M13069 <P>Please see this post regarding How to Get Your Question Answered Quickly: <A href="https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490</A></P> Wed, 08 Apr 2020 20:46:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1016096#M13069 Greg_Deckler 2020-04-08T20:46:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1021249#M13217 The most precise answer is: IT DEPENDS.<BR /><BR />Best<BR />D Sun, 12 Apr 2020 12:08:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SQL-to-PowerBI/m-p/1021249#M13217 Anonymous 2020-04-12T12:08:15Z