Forum Discussion

Jsummers's avatar
Jsummers
Helper I
3 years ago
Solved

Sumif between 2 numbers

Hi All

I am trying to create a measure that shows me overdue invoices between 0-30 day, 31-60 etc. I can not create calculated columns (which I am used to), so having to create measures. I have a measure for the days overdue:

 

Days = SUMX(INVOICES,DATEDIFF(INVOICES[INVOICE_DUE_DATE],TODAY(),DAY))

 

I now want to create a card that shows that total owing for 0-30 days.

 

I have managed to create a measure for a specific day overdue., in this case 9 days, but how can I do between 0-30 days?

 

0-30 = SUMX(FILTER(INVOICES,INVOICES[Days]=9),INVOICES[REM_BALANCE])

 

I have exhausted google!

Thanks

  • I have found the solution:

    0-30 = SUMX(FILTER(INVOICES,INVOICES[Days]>=0 && INVOICES[Days]<=30),INVOICES[REM_BALANCE])

1 Reply

  • I have found the solution:

    0-30 = SUMX(FILTER(INVOICES,INVOICES[Days]>=0 && INVOICES[Days]<=30),INVOICES[REM_BALANCE])