Running totals in power pivot

[jigoro]

I have created a running total measure as below:

=CALCULATE(SUM('Pile Log'[No of Piles]), FILTER(ALLSELECTED('Calendar'[Date]), ISONORAFTER('Calendar'[Date], MAX('Pile Log'[Piling date]), DESC))),

however, when there are periods in my data set without data the chart/pivot table stops i.e. it leaves the period blank - I would like the running total to carry on even through these periods.

How can I achieve this?

 

[alansidman]

See if this is helpful