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...
Ashish_Mathur
Super User
Super UserNowhere in your original post have you shared that the answer should be 2,100. Anyways, the answer should not even be that - it should be 2,000 i.e. 3,500 - 1,500. The revised measure for this will be:
Current month total = SUM(Invoices[Value])+[Receipts]
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
I just cannot understand your question. Someone who does will help you.