How to copy values of previous week when matrix cell is empy?

[QwertyMartijn]

Hey guys,

I have the following code to calculate debtors and creditors, and it calculates the correct values:

However, if a ask powerbi to slice by week, blanks appear. This is because it takes the sum of all changes in balance (but when there are no changes, there is no data, so it leaves a blank).

How can i fix this in my code?

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins