DAX running total that does not recalculate at each group

Hello all,
I have previously asked this question on Mr Excel but had no answer;

https://www.mrexcel.com/board/thread...group.1209902/

The quesition is I have a simple running total measure;

Please Login or Register  to view this content.

but when I have my date column include 'Month' the measure recalculates at the end of each month ; but I'd like it to carry on,
Ive attached a workbook showing Month Date, which recalculates and another with just Date that carries on straight through which is what I'd like both to do.

Richard

There may be an easier way, however this is how I accomplished it:
1. Used Power Query to group Sales by Date which produced the following Advanced Editor code:

Please Login or Register  to view this content.

2. Loaded the resulting table (columns H:J on Sheet 1) into the Data Model
3. In the Data Model added a column (RTDAX2) using the following formula:

Formula:

Please Login or Register  to view this content.

Note that the Month Index and Month columns were added automatically.
4. In the Pivot Table the new column is used in the Values area
Note that subtotals and grand totals don't agree between the Aggregate (sales) column and the RTDAX2 (running total) column, so I chose not to display them.
Let us know if you have any questions.