Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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:
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.
@amirghaderi try this DAX measure:
The numbers dont make sense. any idea why?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |