The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |