topic Running total by Account in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-by-Account/m-p/765624#M3437 <DIV><FONT color="#000000"><SPAN>Hello,<BR /></SPAN></FONT></DIV><DIV><FONT color="#000000"><SPAN>I wanted to create a Running Total column in DAX.</SPAN></FONT></DIV><DIV><FONT color="#000000"><SPAN>I have an Invoice Table which looks like below:</SPAN></FONT></DIV><DIV><TABLE><TBODY><TR><TD>Account ID</TD><TD>Invoice Date&nbsp;</TD><TD>Invoice Price</TD><TD><FONT color="#3366FF">Running Total</FONT></TD></TR><TR><TD>1</TD><TD>10/13/2016</TD><TD>50</TD><TD><FONT color="#3366FF">50</FONT></TD></TR><TR><TD>1</TD><TD>12/10/2017</TD><TD>279</TD><TD><FONT color="#3366FF">329</FONT></TD></TR><TR><TD>1</TD><TD>2/23/2018</TD><TD>1380</TD><TD><FONT color="#3366FF">1709</FONT></TD></TR><TR><TD>2</TD><TD>4/15/2018</TD><TD>325</TD><TD><FONT color="#3366FF">325</FONT></TD></TR><TR><TD>2</TD><TD>3/4/2019</TD><TD>787</TD><TD><FONT color="#3366FF">1112</FONT></TD></TR><TR><TD>3</TD><TD>6/19/2018</TD><TD>2</TD><TD><FONT color="#3366FF">2</FONT></TD></TR><TR><TD>4</TD><TD>9/10/2017</TD><TD>2356</TD><TD><FONT color="#3366FF">2356</FONT></TD></TR><TR><TD>4</TD><TD>7/30/2018</TD><TD>35</TD><TD><FONT color="#3366FF">2391</FONT></TD></TR><TR><TD>4</TD><TD>9/9/2018</TD><TD>254</TD><TD><FONT color="#3366FF">2645</FONT></TD></TR><TR><TD>4</TD><TD>5/7/2019</TD><TD>756</TD><TD><FONT color="#3366FF">3401</FONT></TD></TR><TR><TD>5</TD><TD>3/12/2017</TD><TD>37</TD><TD><FONT color="#3366FF">37</FONT></TD></TR><TR><TD>5</TD><TD>8/26/2018</TD><TD>876</TD><TD><FONT color="#3366FF">913</FONT></TD></TR></TBODY></TABLE></DIV><DIV><FONT color="#000000"><SPAN><BR />My SQL code for that is:</SPAN></FONT></DIV><DIV><FONT color="#3366FF"><SPAN>SELECT&nbsp;</SPAN></FONT><FONT color="#800000"><SPAN>SUM</SPAN></FONT><SPAN>(InvoicePrice)&nbsp;</SPAN><FONT color="#3366FF"><SPAN>OVER</SPAN></FONT><SPAN>&nbsp;(</SPAN><FONT color="#3366FF"><SPAN>Partition</SPAN><SPAN>&nbsp;</SPAN><SPAN>by</SPAN></FONT><SPAN>&nbsp;AccountID&nbsp;</SPAN><FONT color="#3366FF"><SPAN>Order by</SPAN></FONT><SPAN>&nbsp;InvoiceDate)&nbsp;</SPAN><FONT color="#3366FF"><SPAN>as</SPAN></FONT><SPAN>RunningTotal</SPAN></DIV><DIV><FONT color="#3366FF"><SPAN>FROM</SPAN></FONT><SPAN>&nbsp;Invoices</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Note: 1 account can have many invoices so I partitioned by account ID as I want to see running total for each account.</SPAN></DIV> Tue, 13 Aug 2019 18:33:20 GMT mansi64011 2019-08-13T18:33:20Z Running total by Account https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-by-Account/m-p/765624#M3437 <DIV><FONT color="#000000"><SPAN>Hello,<BR /></SPAN></FONT></DIV><DIV><FONT color="#000000"><SPAN>I wanted to create a Running Total column in DAX.</SPAN></FONT></DIV><DIV><FONT color="#000000"><SPAN>I have an Invoice Table which looks like below:</SPAN></FONT></DIV><DIV><TABLE><TBODY><TR><TD>Account ID</TD><TD>Invoice Date&nbsp;</TD><TD>Invoice Price</TD><TD><FONT color="#3366FF">Running Total</FONT></TD></TR><TR><TD>1</TD><TD>10/13/2016</TD><TD>50</TD><TD><FONT color="#3366FF">50</FONT></TD></TR><TR><TD>1</TD><TD>12/10/2017</TD><TD>279</TD><TD><FONT color="#3366FF">329</FONT></TD></TR><TR><TD>1</TD><TD>2/23/2018</TD><TD>1380</TD><TD><FONT color="#3366FF">1709</FONT></TD></TR><TR><TD>2</TD><TD>4/15/2018</TD><TD>325</TD><TD><FONT color="#3366FF">325</FONT></TD></TR><TR><TD>2</TD><TD>3/4/2019</TD><TD>787</TD><TD><FONT color="#3366FF">1112</FONT></TD></TR><TR><TD>3</TD><TD>6/19/2018</TD><TD>2</TD><TD><FONT color="#3366FF">2</FONT></TD></TR><TR><TD>4</TD><TD>9/10/2017</TD><TD>2356</TD><TD><FONT color="#3366FF">2356</FONT></TD></TR><TR><TD>4</TD><TD>7/30/2018</TD><TD>35</TD><TD><FONT color="#3366FF">2391</FONT></TD></TR><TR><TD>4</TD><TD>9/9/2018</TD><TD>254</TD><TD><FONT color="#3366FF">2645</FONT></TD></TR><TR><TD>4</TD><TD>5/7/2019</TD><TD>756</TD><TD><FONT color="#3366FF">3401</FONT></TD></TR><TR><TD>5</TD><TD>3/12/2017</TD><TD>37</TD><TD><FONT color="#3366FF">37</FONT></TD></TR><TR><TD>5</TD><TD>8/26/2018</TD><TD>876</TD><TD><FONT color="#3366FF">913</FONT></TD></TR></TBODY></TABLE></DIV><DIV><FONT color="#000000"><SPAN><BR />My SQL code for that is:</SPAN></FONT></DIV><DIV><FONT color="#3366FF"><SPAN>SELECT&nbsp;</SPAN></FONT><FONT color="#800000"><SPAN>SUM</SPAN></FONT><SPAN>(InvoicePrice)&nbsp;</SPAN><FONT color="#3366FF"><SPAN>OVER</SPAN></FONT><SPAN>&nbsp;(</SPAN><FONT color="#3366FF"><SPAN>Partition</SPAN><SPAN>&nbsp;</SPAN><SPAN>by</SPAN></FONT><SPAN>&nbsp;AccountID&nbsp;</SPAN><FONT color="#3366FF"><SPAN>Order by</SPAN></FONT><SPAN>&nbsp;InvoiceDate)&nbsp;</SPAN><FONT color="#3366FF"><SPAN>as</SPAN></FONT><SPAN>RunningTotal</SPAN></DIV><DIV><FONT color="#3366FF"><SPAN>FROM</SPAN></FONT><SPAN>&nbsp;Invoices</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Note: 1 account can have many invoices so I partitioned by account ID as I want to see running total for each account.</SPAN></DIV> Tue, 13 Aug 2019 18:33:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-by-Account/m-p/765624#M3437 mansi64011 2019-08-13T18:33:20Z Re: Running total by Account https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-by-Account/m-p/766584#M3481 Why in DAX and not in Power Query, where you should do it?<BR /><BR />Best<BR />Darek Wed, 14 Aug 2019 14:25:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-by-Account/m-p/766584#M3481 Anonymous 2019-08-14T14:25:19Z