Forum Discussion

Anonymous

Not applicable

2 years ago

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...

Icon for Super User rank

Super User

2 years ago

Hi,

Your answer of Balance seems wrong. PBI file attached.

Hope this helps.

Balance.pbix62 KB

Anonymous
Not applicable
2 years ago
Ashish_Mathur
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
  Super User
  2 years ago
  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]
  - Anonymous
    Not applicable
    2 years ago
    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.