topic Re: Calculate production - investment only for the first year in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/773643#M3813 <P>Should be something along the lines of:</P> <P>&nbsp;</P> <PRE>Investment = IF([Production]&lt;=0,BLANK(),[Production] - [Production Investment])</PRE> Thu, 22 Aug 2019 21:40:14 GMT Greg_Deckler 2019-08-22T21:40:14Z Calculate production - investment only for the first year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/773633#M3811 <P>Hello I need to calculate the difference between production and Investment but only for the year In which the production starts, that means that Production &gt; 0, using DAX like in the following table, can you help me?</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>Year</TD><TD>Production</TD><TD>Production - Investment</TD><TD>Investment</TD></TR><TR><TD>A</TD><TD>1</TD><TD>100</TD><TD>-600</TD><TD>700</TD></TR><TR><TD>A</TD><TD>2</TD><TD>50</TD><TD>50</TD><TD>&nbsp;</TD></TR><TR><TD>A</TD><TD>3</TD><TD>20</TD><TD>20</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>2</TD><TD>500</TD><TD>-200</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>3</TD><TD>400</TD><TD>400</TD><TD>&nbsp;</TD></TR><TR><TD>C</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>&nbsp;</TD></TR><TR><TD>C</TD><TD>2</TD><TD>100</TD><TD>-600</TD><TD>&nbsp;</TD></TR><TR><TD>C</TD><TD>2</TD><TD>789</TD><TD>798</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Thu, 22 Aug 2019 21:12:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/773633#M3811 OscarSuarez10 2019-08-22T21:12:32Z Re: Calculate production - investment only for the first year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/773643#M3813 <P>Should be something along the lines of:</P> <P>&nbsp;</P> <PRE>Investment = IF([Production]&lt;=0,BLANK(),[Production] - [Production Investment])</PRE> Thu, 22 Aug 2019 21:40:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/773643#M3813 Greg_Deckler 2019-08-22T21:40:14Z Re: Calculate production - investment only for the first year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/774296#M3838 <P>Hello, Thank You for your help, the thing is that I need to subtract the investment only in the year when the production starts&nbsp; &nbsp;(production &gt; 0) , how can I do that?&nbsp;</P> Fri, 23 Aug 2019 12:43:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-production-investment-only-for-the-first-year/m-p/774296#M3838 OscarSuarez10 2019-08-23T12:43:01Z