Help with virtual table/advanced summarize?

Hey team, I facing the following scenario. I have financial data of receipts and invoices for our customers and I need to figure out the amount of 'active debtors' at the end of each week.

I am able to summarize the data when manually set the date informations (the week ending date) but I need to find a way how to be able to use this in one measure against the week table.

I have attached the example data with last three weeks created manually with summarize. Can you please help me to have this all done with one measure only?

Test Table.pbix

TIA