cancel
Showing results for
Did you mean:
Helper III

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

1 ACCEPTED SOLUTION
Super User II

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
5 REPLIES 5
Helper III

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.

Super User II

@amirghaderi  try this DAX measure:

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
Helper III

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

Super User II

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
Helper III

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

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.