Forum Discussion

Copper Contributor

Dec 20, 2021

Solved

Running total in for Month-Year

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.

BI & Data Analysis

excel

SergeiBaklan
Dec 21, 2021
thangvan

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

4 Replies

SergeiBaklan
Diamond Contributor
Dec 21, 2021
thangvan

You may use patterns from Computing running totals in DAX - SQLBI to build your measures for PivotTable.
- thangvan
  Copper Contributor
  Dec 21, 2021
  Thank you Sergei, problem solved following your suggestion.
  - SergeiBaklan
    Diamond Contributor
    Dec 21, 2021
    thangvan , glad it helped.
Martin_Weiss
Bronze Contributor
Dec 21, 2021
Hi thangvan

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