accumulated value not shown if there is no entry in the month

[Johan]

Hi,

I have this dax formula to accumulate the value over time periods:

amount accum. = calculate(sum(fact[amount]), filter(all(periods);Periods[Period] <= max(Periods[Period])))

it calculates correctly, but if I put it in a matrix table it does not show a value if there is no entry in the period.

So, it shows like this:

Account 201701 201702 201703 201704 Total
1          500           800   1000   1000
2         1000   1200          1800   1800
3          600    700                  700
Ttl       2000   2300   2700   3500   3500

How to get a value in each cell, also for periods where there is no entry on the account?

Thanks,

Johan