Forum Discussion
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 |
B | 9/04/2021 | 1500 | B+A | 2500 |
C | 16/04/2021 | 1200 | C+B+A | 3700 |
D | 23/04/2021 | 1700 | D+C+B | 4400 |
E | 30/04/2021 | 500 | E+D+C | 3400 |
F | 7/05/2021 | 600 | F+E+D | 2800 |
G | 14/05/2021 | 900 | G+F+E | 2000 |
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:
5 Replies
amirghaderi try this DAX measure:
Measure = CALCULATE (SUM ( TableName[EV] ),FILTER (ALL ( TableName ),TableName[Date] <= MAX (TableName[Date])&& TableName[Date] = MAX ( TableName[Date] ) - 14))The numbers dont make sense. any idea why?
Measure = CALCULATE (SUM ( Source[Period:Earned] ),FILTER (ALL ( Source ),Source[To Date.2] <= MAX (Source[To Date.2]) && (Source[To Date.2] >= MAX ( (Source[To Date.2]))-14)))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.
