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 me...
Need Help
  • Jsummers's avatar
    Jsummers
    3 years ago

    I have found the solution:

    0-30 = SUMX(FILTER(INVOICES,INVOICES[Days]>=0 && INVOICES[Days]<=30),INVOICES[REM_BALANCE])
Jsummers's avatar
Jsummers
Helper I
3 years ago

I have found the solution:

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