Dec 20 2021 08:45 PM
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.
Dec 21 2021 12:00 AM
Hi @thangvan
could you please post a screenshot of your pivot, so it will be easier to provide a solution.
Dec 21 2021 03:46 AM
SolutionYou may use patterns from Computing running totals in DAX - SQLBI to build your measures for PivotTable.
Dec 21 2021 06:55 PM
Dec 21 2021 03:46 AM
SolutionYou may use patterns from Computing running totals in DAX - SQLBI to build your measures for PivotTable.