Forum Discussion

lizardi89's avatar
lizardi89
Helper I
1 year ago

Progression Measure

Hello, 

I'm trying to build a progression matrix to see how a balance moves in time but the filters i'm using are not working.

My company has some outstanig invoices and I want to follow their days past due throughout time.
This is my data

 

My formula is

Measure = CALCULATE(SUM([amount]),LASTDATE([date]))

 

I expect my table to look like this 

 

But it looks like this, the values repeat each month because they passed through the range in that month

 I have tried to use different fillters but haven't figured it out 

 

Thank you in advanced

6 Replies

  • Isn't there an option to filter it out instead of making another table?

    • lbendlin's avatar
      lbendlin
      Super User

      yes, filter out all dates which have DAY = 15

      • lizardi89's avatar
        lizardi89
        Helper I

        This is just an example, my table has multiple dates and multiple clients