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:

     

Tahreem24's avatar
Tahreem24
Super User
5 years ago

amirghaderi  try this DAX measure:

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