Forum Discussion
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...
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 try this DAX measure:
Measure = CALCULATE (SUM ( TableName[EV] ),FILTER (ALL ( TableName ),TableName[Date] <= MAX (TableName[Date])
&& TableName[Date] = MAX ( TableName[Date] ) - 14))
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 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:
Thanks, It worked. I only chnaged the filter to Allselected to make sure the filter applied to the report works on measure as well.