Forum Discussion
Solved
Moving Sum
Hi, I am looking for moving 3 weeks sum measure for a column value. Example as below: Can anybody help? Record Date EV Moving Sum RESULT A 2/04/2021 1000 A 1000...
amirghaderi as per the informtation provided and data attached in very first post I used that and generated the expected result. See the screen shot below:
One more question,
If I want in another measure, only the MA for last period comes and every previous period becomes zero, then how to chnage the filter?
For example, in the above table, I want to see MA calculated for period 16-Apr-2021 and zero for everything else.