https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/subtracting-two-columns/m-p/1832198#M38976 <P>Hey guys,</P><P>&nbsp;</P><P>Im trying to compute a very easy dax that i cant compute.</P><P>Im just trying to substract two columns fom the same table with the follow dax:</P><P>&nbsp;</P><DIV><DIV><SPAN>dZ2Cantidad = sum('Z2'[Cons. Qty.])- sum('Z2'[Prod.Net.Qty.])</SPAN></DIV></DIV><P><SPAN><BR /><BR /><BR /></SPAN></P><P><SPAN>The result i am getting is (4.599.271,34) when it should be (2.303.276)<BR /><BR /><BR /></SPAN></P><P><SPAN>What&nbsp; i am doing wrong?</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks in advance</SPAN></P> Mon, 10 May 2021 00:33:16 GMT Anonymous 2021-05-10T00:33:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/subtracting-two-columns/m-p/1832198#M38976 <P>Hey guys,</P><P>&nbsp;</P><P>Im trying to compute a very easy dax that i cant compute.</P><P>Im just trying to substract two columns fom the same table with the follow dax:</P><P>&nbsp;</P><DIV><DIV><SPAN>dZ2Cantidad = sum('Z2'[Cons. Qty.])- sum('Z2'[Prod.Net.Qty.])</SPAN></DIV></DIV><P><SPAN><BR /><BR /><BR /></SPAN></P><P><SPAN>The result i am getting is (4.599.271,34) when it should be (2.303.276)<BR /><BR /><BR /></SPAN></P><P><SPAN>What&nbsp; i am doing wrong?</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks in advance</SPAN></P> Mon, 10 May 2021 00:33:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/subtracting-two-columns/m-p/1832198#M38976 Anonymous 2021-05-10T00:33:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/subtracting-two-columns/m-p/1832250#M38977 <P>Can you please share your data or sample power BI file?</P> Mon, 10 May 2021 02:10:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/subtracting-two-columns/m-p/1832250#M38977 Anonymous 2021-05-10T02:10:10Z