Forum Discussion
CALCULATE measure for current month
Trying to calculate only the selected month outstanding invoices from an Invoice & Receipts table and the measure is not working as expected. Selected date can be any date in previous months. If...
Sorry Ashish_Mathur . I think i didn't make it clear in my earlier post.
Current Balance is actually the invoices that is balance for the month selected. So if there is a receipt for an invoice from previous month that should NOT be in the current month balance.
In the example i shared, only INV-1 & INV-2 are the invoices paid to be accounted for receipts. That's why receipts is 1400.
Ashish_Mathur
Super User
Super UserI just cannot understand your question. Someone who does will help you.