Running for Current Week starting on a Monday

[JMckeever5]

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

[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.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?