topic Re: Acumulate value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326589#M23414 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a><STRONG>&nbsp;,&nbsp;</STRONG>but balance is same as amount with new column code</P><P>&nbsp;</P><DIV><DIV><SPAN>balance = sumx( filter(table, table[number] = earlier(table[number]) &amp;&amp; table[index] = earlier(table[index])),table[amount])</SPAN></DIV></DIV><P>&nbsp;</P><P><STRONG>index&nbsp; number&nbsp; amount&nbsp; balance</STRONG><BR /><SPAN>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</SPAN><BR /><SPAN>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp;</SPAN><BR /><SPAN>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; 20</SPAN><BR /><SPAN>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-20&nbsp; &nbsp; &nbsp; &nbsp;-20&nbsp; &nbsp;</SPAN><BR /><SPAN>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 10</SPAN><BR /><SPAN>6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 10</SPAN><BR /><SPAN>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><STRONG>10</STRONG><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; -10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;<SPAN>&nbsp;</SPAN><STRONG>10</STRONG></FONT></P><P>&nbsp;</P><P><FONT face="arial,helvetica,sans-serif" color="#000000">Did I write something wrong?</FONT></P> Wed, 26 Aug 2020 17:11:29 GMT geerduran 2020-08-26T17:11:29Z Acumulate value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326270#M23396 <P><SPAN>Hello, I have a dataset like this</SPAN></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><STRONG>index&nbsp; number&nbsp; amount&nbsp; balance</STRONG><BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20<BR />4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp;<BR />5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10<BR />6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20<BR />7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp;30</STRONG><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp; 20</STRONG></FONT></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>I would like to get the Number of column&nbsp;<STRONG>balance</STRONG> acumulated by number group.</SPAN></P><P><SPAN>Thanx in advance for help</SPAN></P> Wed, 26 Aug 2020 15:03:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326270#M23396 geerduran 2020-08-26T15:03:54Z Re: Acumulate value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326281#M23397 <P>This is an answer</P><P>&nbsp;</P><DIV><DIV><SPAN>balance = </SPAN></DIV><DIV><SPAN>CALCULATE (</SPAN></DIV><DIV><SPAN>SUMX ( 'Table', [amount] ),</SPAN></DIV><DIV><SPAN>FILTER (</SPAN></DIV><DIV><SPAN>ALLEXCEPT ( 'Table', 'Table'[number] ),</SPAN></DIV><DIV><SPAN>'Table'[index] &lt;= MAX ( 'Table'[index] )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Wed, 26 Aug 2020 15:11:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326281#M23397 geerduran 2020-08-26T15:11:12Z Re: Acumulate value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326397#M23402 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="138662" data-lia-user-login="geerduran" class="lia-mention lia-mention-user">geerduran</a> , New measure</P> <P>calculate(sum(Table[amount]) , filter(allselected(Table), table[number] = max(table[number]) &amp;&amp; table[index] = max(table[index])))</P> <P>&nbsp;</P> <P>new column</P> <P>sumx( filter(Table, table[number] = earlier(table[number]) &amp;&amp; table[index] = earlier(table[index])),Table[amount])</P> Wed, 26 Aug 2020 15:57:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326397#M23402 amitchandak 2020-08-26T15:57:24Z Re: Acumulate value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326589#M23414 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a><STRONG>&nbsp;,&nbsp;</STRONG>but balance is same as amount with new column code</P><P>&nbsp;</P><DIV><DIV><SPAN>balance = sumx( filter(table, table[number] = earlier(table[number]) &amp;&amp; table[index] = earlier(table[index])),table[amount])</SPAN></DIV></DIV><P>&nbsp;</P><P><STRONG>index&nbsp; number&nbsp; amount&nbsp; balance</STRONG><BR /><SPAN>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</SPAN><BR /><SPAN>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp;</SPAN><BR /><SPAN>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; 20</SPAN><BR /><SPAN>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-20&nbsp; &nbsp; &nbsp; &nbsp;-20&nbsp; &nbsp;</SPAN><BR /><SPAN>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 10</SPAN><BR /><SPAN>6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 10</SPAN><BR /><SPAN>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10775&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><STRONG>10</STRONG><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10&nbsp; &nbsp; &nbsp; -10</FONT><BR /><FONT face="arial,helvetica,sans-serif" color="#000000">11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10776&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp;<SPAN>&nbsp;</SPAN><STRONG>10</STRONG></FONT></P><P>&nbsp;</P><P><FONT face="arial,helvetica,sans-serif" color="#000000">Did I write something wrong?</FONT></P> Wed, 26 Aug 2020 17:11:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Acumulate-value/m-p/1326589#M23414 geerduran 2020-08-26T17:11:29Z