Forum Discussion
CALCULATE measure for current month
Super UserHi,
Your answer of Balance seems wrong. PBI file attached.
Hope this helps.
Sorry. That is not adding up for Current month total. That is the issue that i posted.
For Sep , there are 3 invoices that adds up to 3500 (500 + 1000 + 2000) and receipts for SEP invoices adds up to 1400 (200 + 200 + 1000 ) . Current month total should show as 2100 and not 2250.
- Ashish_Mathur
Nowhere 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.