https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654522#M178181 <P>Hi Anonymous</LI-USER>&nbsp;</P><P>You can use for example that your table name is sales</P><P>Running total= CALCULATE(SUM(Sales[amount]),Filter(ALL(Calendar[Date]),Calendar[Date]&lt;=MAX(Calendar[Date])))</P><P>&nbsp;</P><P>Let me know if this works</P> Tue, 15 Apr 2025 18:35:01 GMT powerbidev123 2025-04-15T18:35:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654515#M178179 <P>I need DAX solution for rnning total sales for 1&nbsp; of my report.&nbsp;</P><P>Thanks in advance</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Apr 2025 18:31:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654515#M178179 Anonymous 2025-04-15T18:31:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654522#M178181 <P>Hi Anonymous</LI-USER>&nbsp;</P><P>You can use for example that your table name is sales</P><P>Running total= CALCULATE(SUM(Sales[amount]),Filter(ALL(Calendar[Date]),Calendar[Date]&lt;=MAX(Calendar[Date])))</P><P>&nbsp;</P><P>Let me know if this works</P> Tue, 15 Apr 2025 18:35:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654522#M178181 powerbidev123 2025-04-15T18:35:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654524#M178182 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="752610" data-lia-user-login="powerbidev123" class="lia-mention lia-mention-user">powerbidev123</a>&nbsp;, It works</P> Tue, 15 Apr 2025 18:35:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/running-total-of-sales/m-p/4654524#M178182 Anonymous 2025-04-15T18:35:54Z