cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amirghaderi
Helper III
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

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

Capture.PNG

 

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

View solution in original post

5 REPLIES 5
amirghaderi
Helper III
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.

 

Tahreem24
Super User II
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

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_0-1619081248019.png

 

 

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

Capture.PNG

 

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

View solution in original post

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

amirghaderi_0-1619144987580.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

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

MBAS on Demand

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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors