Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
5 years ago
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...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    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's avatar
amirghaderi
Helper IV
5 years ago

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's avatar
Tahreem24
Super User
5 years ago

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's avatar
    amirghaderi
    Helper IV
    5 years ago

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