Calculate outstanding balance for each month

[kruizing]

Hi all!

I am trying to calculate the outstanding balance by the end of each month. I have three tables, Date, Invoices and payments. Invoices and payments are related on FactuurSleutel (InvoiceKey), Invoice and date are related on Boekdatum and Datum.

I have played around with some different DAX functions but unfortunatly without any result. Is there somebody who can point me in the right direction?

Thank you very much in advance!

[amitchandak]

@kruizing , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[kruizing]

Hi @amitchandak 

I hope this wil work

Link to sample