topic Re: Calculating cummulative total by date and by id in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3274906#M121473 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="555045" data-lia-user-login="some_bih" class="lia-mention lia-mention-user">some_bih</a></P><P>Will DATESYTD work with whole date series before and after 2023 as well as i would need cummulative total as of any dates?</P> Thu, 08 Jun 2023 14:55:46 GMT RahulKumarBIT 2023-06-08T14:55:46Z Calculating cummulative total by date and by id https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3273446#M121401 <P>Hi</P><P>I am looking to calculate cummulative total by date and by id. My existing table and its three column's are per below</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>Amount</TD></TR><TR><TD>01/31/2023</TD><TD>501</TD><TD>5</TD></TR><TR><TD>02/28/2023</TD><TD>501</TD><TD>10</TD></TR><TR><TD>01/31/2023</TD><TD>502</TD><TD>3</TD></TR><TR><TD>02/28/2023</TD><TD>502</TD><TD>6</TD></TR></TBODY></TABLE><P>Expected Table with 4rth calculated column-CummulativeAmount</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>Amount</TD><TD>CummulativeAmount</TD></TR><TR><TD>01/31/2023</TD><TD>501</TD><TD>5</TD><TD>5</TD></TR><TR><TD>02/28/2023</TD><TD>501</TD><TD>10</TD><TD>15</TD></TR><TR><TD>01/31/2023</TD><TD>502</TD><TD>3</TD><TD>3</TD></TR><TR><TD>02/28/2023</TD><TD>502</TD><TD>6</TD><TD>9</TD></TR></TBODY></TABLE> Wed, 07 Jun 2023 20:51:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3273446#M121401 RahulKumarBIT 2023-06-07T20:51:51Z Re: Calculating cummulative total by date and by id https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3273492#M121404 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="571613" data-lia-user-login="RahulKumarBIT" class="lia-mention lia-mention-user">RahulKumarBIT</a>&nbsp;, create two measures:</P><DIV><DIV><SPAN>Sales Amount = </SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Sheet2</SPAN><SPAN>[Amount]</SPAN><SPAN>) and</SPAN></DIV><DIV><DIV><DIV><SPAN>Cummulative Amount = </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; [Sales Amount],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATESYTD</SPAN><SPAN>(Sheet2[Date])</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;Columns and ID are from table Sheet2, so you need to adjust to your table name. Please note that visual is created as you shown. I hope this help.</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV></DIV></DIV> Wed, 07 Jun 2023 21:25:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3273492#M121404 some_bih 2023-06-07T21:25:33Z Re: Calculating cummulative total by date and by id https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3274906#M121473 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="555045" data-lia-user-login="some_bih" class="lia-mention lia-mention-user">some_bih</a></P><P>Will DATESYTD work with whole date series before and after 2023 as well as i would need cummulative total as of any dates?</P> Thu, 08 Jun 2023 14:55:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-cummulative-total-by-date-and-by-id/m-p/3274906#M121473 RahulKumarBIT 2023-06-08T14:55:46Z