Moving Sum

[amirghaderi]

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]

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.

[Tahreem24]

@amirghaderi  try this DAX measure:

Measure = CALCULATE (SUM ( TableName[EV] ),FILTER (ALL ( TableName ),TableName[Date] <= MAX (TableName[Date])

&& TableName[Date] = MAX ( TableName[Date] ) - 14))

[amirghaderi]

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)))

[Tahreem24 · Accepted solution]

@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:

[amirghaderi]

Thanks, It worked. I only chnaged the filter to Allselected to make sure the filter applied to the report works on measure as well.