SOLVED

Running total in for Month-Year

Copper 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 (Copper Contributor)
Solution

@thangvan 

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.

1 best response

Accepted Solutions
best response confirmed by thangvan (Copper Contributor)
Solution

@thangvan 

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

View solution in original post