topic Re: Summing up column starting with specific row in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-up-column-starting-with-specific-row/m-p/2830297#M90140 <P>Okay, I've figured it out, here is the code:</P><DIV><DIV><SPAN>= </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Count</SPAN><SPAN>), </SPAN><SPAN>[Code]</SPAN><SPAN> &gt;= </SPAN><SPAN>EARLIER</SPAN><SPAN>(</SPAN><SPAN>[Code]</SPAN><SPAN>), </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Table</SPAN><SPAN>) )</SPAN></DIV></DIV> Mon, 10 Oct 2022 08:27:47 GMT Anonymous 2022-10-10T08:27:47Z Summing up column starting with specific row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-up-column-starting-with-specific-row/m-p/2830188#M90133 <P>Hello! I have this table:&nbsp;</P><TABLE border="1"><TBODY><TR><TD>count</TD><TD>id</TD><TD>sum</TD></TR><TR><TD>15</TD><TD>1</TD><TD>15+10+5+3+1</TD></TR><TR><TD>10</TD><TD>2</TD><TD>10+5+3+1</TD></TR><TR><TD>5</TD><TD>3</TD><TD>5+3+1</TD></TR><TR><TD>3</TD><TD>4</TD><TD>3+1</TD></TR><TR><TD>1</TD><TD>5</TD><TD>1</TD></TR></TBODY></TABLE><P>So I need he "sum" column that will calculate the sum of "count" values starting with current id till the last, not including previous id. Thanks in advance!</P> Mon, 10 Oct 2022 07:53:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-up-column-starting-with-specific-row/m-p/2830188#M90133 Anonymous 2022-10-10T07:53:47Z Re: Summing up column starting with specific row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-up-column-starting-with-specific-row/m-p/2830297#M90140 <P>Okay, I've figured it out, here is the code:</P><DIV><DIV><SPAN>= </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Count</SPAN><SPAN>), </SPAN><SPAN>[Code]</SPAN><SPAN> &gt;= </SPAN><SPAN>EARLIER</SPAN><SPAN>(</SPAN><SPAN>[Code]</SPAN><SPAN>), </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Table</SPAN><SPAN>) )</SPAN></DIV></DIV> Mon, 10 Oct 2022 08:27:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-up-column-starting-with-specific-row/m-p/2830297#M90140 Anonymous 2022-10-10T08:27:47Z