Forum Discussion
lizardi89
1 year agoHelper I
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