Forum Discussion
Running for Current Week starting on a Monday
Hi there, can anyone help. I have created a measure which calculates the last 4 weeks Totals, using a l4W start Date and L4w End Date.
__Step2 = AVERAGEX('Sales Dates',
Calculate(sum(Sales[Sales (GBP)]),
FILTER('Sales Dates','Sales Dates'[Date] <= [__L4w End Date] && 'Sales Dates'[Date] >= [__L4w Start Date]))/4. This works 100%. I am battling now to create a rolling 4 weak measure. Can anyone please assist.
| Monday | 589 | ||
| Tuesday | 547 | ||
| Wednesday | 501 | ||
| Thursday | 496 | ||
| Friday | 492 | ||
| Saturday | 73 | ||
| Sunday | 21 |
2 Replies
- lbendlin
Super User
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
- Ashish_Mathur
Hi,
Share data in a format that can be pasted in an MS Excel file. Show the expected result on the sample that you share.
