Running total in for Month-Year

Occasional Contributor

Hello, can you please help? I have a pivot table that have column Date & Submission. I have grouped DATE by Month-Year. How do I calculate the running total in Month-Year (default option only allow running total in with base value either date, month or year. Thank you.

4 Replies

Hi @thangvan 


could you please post a screenshot of your pivot, so it will be easier to provide a solution.

best response confirmed by thangvan (Occasional Contributor)


You may use patterns from Computing running totals in DAX - SQLBI to build your measures for PivotTable. 

Thank you Sergei, problem solved following your suggestion.

@thangvan , glad it helped.