topic Calculated column for ClosingStk using DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-for-ClosingStk-using-DAX/m-p/3672891#M142498 <P>Hi,</P><P>&nbsp;</P><P>In below table, I would like to calculate ClosingStk based on ShiftDate and SizeNo.</P><P>The first ClosingStk for the same SizeNo should be using InitialStkCount (column G) + CuredQty (column D) - StkInQty (column C).</P><P>Subsequent and remaining ClosingQty for the same SizeNo should be using ClosingStk from previous row&nbsp;(column F) + CuredQty (column D) - StkInQty (column C).</P><P>Please help.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ShiftDate</TD><TD>SizeNo</TD><TD>StkInQty</TD><TD>CuredQty</TD><TD>InitialStkCount</TD><TD>&nbsp;</TD><TD>Closing<BR />Stk</TD></TR><TR><TD>1/1/2024</TD><TD>A001</TD><TD>&nbsp;</TD><TD>100</TD><TD>333</TD><TD>&nbsp;</TD><TD>433</TD></TR><TR><TD>2/1/2024</TD><TD>A001</TD><TD>864</TD><TD>964</TD><TD>&nbsp;</TD><TD>433</TD><TD>533</TD></TR><TR><TD>3/1/2024</TD><TD>A001</TD><TD>160</TD><TD>263</TD><TD>&nbsp;</TD><TD>533</TD><TD>636</TD></TR><TR><TD>4/1/2024</TD><TD>A001</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>636</TD><TD>636</TD></TR><TR><TD>5/1/2024</TD><TD>A001</TD><TD>345</TD><TD>550</TD><TD>&nbsp;</TD><TD>636</TD><TD>841</TD></TR><TR><TD>2/1/2024</TD><TD>B001</TD><TD>112</TD><TD>128</TD><TD>86</TD><TD>&nbsp;</TD><TD>102</TD></TR><TR><TD>3/1/2024</TD><TD>B001</TD><TD>68</TD><TD>52</TD><TD>&nbsp;</TD><TD>102</TD><TD>86</TD></TR><TR><TD>4/1/2024</TD><TD>B001</TD><TD>235</TD><TD>300</TD><TD>&nbsp;</TD><TD>86</TD><TD>151</TD></TR><TR><TD>5/1/2024</TD><TD>B001</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>151</TD><TD>151</TD></TR><TR><TD>2/1/2024</TD><TD>C001</TD><TD>280</TD><TD>336</TD><TD>268</TD><TD>&nbsp;</TD><TD>324</TD></TR><TR><TD>3/1/2024</TD><TD>C001</TD><TD>112</TD><TD>126</TD><TD>&nbsp;</TD><TD>324</TD><TD>338</TD></TR><TR><TD>4/1/2024</TD><TD>C001</TD><TD>135</TD><TD>250</TD><TD>&nbsp;</TD><TD>338</TD><TD>453</TD></TR><TR><TD>5/1/2024</TD><TD>C001</TD><TD>325</TD><TD>400</TD><TD>&nbsp;</TD><TD>453</TD><TD>528</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you.</P><P>&nbsp;</P><P>Regards,</P><P>LC</P> Thu, 01 Feb 2024 12:15:39 GMT Tan_LC 2024-02-01T12:15:39Z Calculated column for ClosingStk using DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-for-ClosingStk-using-DAX/m-p/3672891#M142498 <P>Hi,</P><P>&nbsp;</P><P>In below table, I would like to calculate ClosingStk based on ShiftDate and SizeNo.</P><P>The first ClosingStk for the same SizeNo should be using InitialStkCount (column G) + CuredQty (column D) - StkInQty (column C).</P><P>Subsequent and remaining ClosingQty for the same SizeNo should be using ClosingStk from previous row&nbsp;(column F) + CuredQty (column D) - StkInQty (column C).</P><P>Please help.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ShiftDate</TD><TD>SizeNo</TD><TD>StkInQty</TD><TD>CuredQty</TD><TD>InitialStkCount</TD><TD>&nbsp;</TD><TD>Closing<BR />Stk</TD></TR><TR><TD>1/1/2024</TD><TD>A001</TD><TD>&nbsp;</TD><TD>100</TD><TD>333</TD><TD>&nbsp;</TD><TD>433</TD></TR><TR><TD>2/1/2024</TD><TD>A001</TD><TD>864</TD><TD>964</TD><TD>&nbsp;</TD><TD>433</TD><TD>533</TD></TR><TR><TD>3/1/2024</TD><TD>A001</TD><TD>160</TD><TD>263</TD><TD>&nbsp;</TD><TD>533</TD><TD>636</TD></TR><TR><TD>4/1/2024</TD><TD>A001</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>636</TD><TD>636</TD></TR><TR><TD>5/1/2024</TD><TD>A001</TD><TD>345</TD><TD>550</TD><TD>&nbsp;</TD><TD>636</TD><TD>841</TD></TR><TR><TD>2/1/2024</TD><TD>B001</TD><TD>112</TD><TD>128</TD><TD>86</TD><TD>&nbsp;</TD><TD>102</TD></TR><TR><TD>3/1/2024</TD><TD>B001</TD><TD>68</TD><TD>52</TD><TD>&nbsp;</TD><TD>102</TD><TD>86</TD></TR><TR><TD>4/1/2024</TD><TD>B001</TD><TD>235</TD><TD>300</TD><TD>&nbsp;</TD><TD>86</TD><TD>151</TD></TR><TR><TD>5/1/2024</TD><TD>B001</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>151</TD><TD>151</TD></TR><TR><TD>2/1/2024</TD><TD>C001</TD><TD>280</TD><TD>336</TD><TD>268</TD><TD>&nbsp;</TD><TD>324</TD></TR><TR><TD>3/1/2024</TD><TD>C001</TD><TD>112</TD><TD>126</TD><TD>&nbsp;</TD><TD>324</TD><TD>338</TD></TR><TR><TD>4/1/2024</TD><TD>C001</TD><TD>135</TD><TD>250</TD><TD>&nbsp;</TD><TD>338</TD><TD>453</TD></TR><TR><TD>5/1/2024</TD><TD>C001</TD><TD>325</TD><TD>400</TD><TD>&nbsp;</TD><TD>453</TD><TD>528</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you.</P><P>&nbsp;</P><P>Regards,</P><P>LC</P> Thu, 01 Feb 2024 12:15:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-for-ClosingStk-using-DAX/m-p/3672891#M142498 Tan_LC 2024-02-01T12:15:39Z Re: Calculated column for ClosingStk using DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-for-ClosingStk-using-DAX/m-p/3673509#M142535 <P><img /></P> <P>&nbsp;</P> <P>for fun only, a showcase of powerful Excel formulas,</P> <P><img /></P> Thu, 01 Feb 2024 16:51:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-column-for-ClosingStk-using-DAX/m-p/3673509#M142535 ThxAlot 2024-02-01T16:51:29Z