Rolling average of previous number of days totals

  • Thread starter Thread starter Legacy 167309
  • Start date Start date
L

Legacy 167309

Guest
Hi.

Using PowerPivot I am looking to generate the rolling average of total daily sales value per person for the previous seven days, inclusive of days where there are no sales for that individual. I have considered a measure using a calculate function with DATESINPERIOD but I only get the average of all the values within that date range as opposed to an average of the sum of each day.

avg 7day Sales:=CALCULATE(average('SalesData'[sales value]),DATESINPERIOD(DatesTable[Date],PREVIOUSDAY(DatesTable[Date]),-7,DAY),ALL(DatesTable[Date]))


I know this will be simple but I’ve been thinking about it for too long. Could anyone help or guide me in the relevant direction.

Thanks.

G

Prefered outcome:

<tbody>
[TD="class: xl65, align: center"]24/06/2016[/TD]
[TD="class: xl66, align: center"]7500[/TD]

[TD="class: xl65, align: center"]25/06/2016[/TD]
[TD="class: xl66, align: center"]7471[/TD]

[TD="class: xl65, align: center"]26/06/2016[/TD]
[TD="class: xl66, align: center"]7471[/TD]

[TD="class: xl65, align: center"]27/06/2016[/TD]
[TD="class: xl66, align: center"]7471[/TD]

[TD="class: xl65, align: center"]28/06/2016[/TD]
[TD="class: xl66, align: center"]6357[/TD]

[TD="class: xl65, align: center"]29/06/2016[/TD]
[TD="class: xl66, align: center"]5686[/TD]

[TD="class: xl65, align: center"]30/06/2016[/TD]
[TD="class: xl66, align: center"]5686[/TD]

[TD="class: xl65, align: center"]01/07/2016[/TD]
[TD="class: xl66, align: center"]5771[/TD]

</tbody>


Example data:




WeekDatePersonSales Value
Wk 1Person 1
Wk 1Person 1
Wk 1Person 10
Wk 1Person 10
Wk 1Person 2
Wk 1Person 2
Wk 1Person 3
Wk 1Person 3
Wk 1Person 4
Wk 1Person 4
Wk 1Person 5
Wk 1Person 5
Wk 1Person 6
Wk 1Person 6
Wk 1Person 7
Wk 1Person 7
Wk 1Person 8
Wk 1Person 8
Wk 1Person 9
Wk 1Person 1
Wk 1Person 1
Wk 1Person 10
Wk 1Person 10
Wk 1Person 2
Wk 1Person 2
Wk 1Person 3
Wk 1Person 3
Wk 1Person 4
Wk 1Person 5
Wk 1Person 5
Wk 1Person 6
Wk 1Person 6
Wk 1Person 7
Wk 1Person 7
Wk 1Person 8
Wk 1Person 9
Wk 1Person 9
Wk 1Person 1
Wk 1Person 1
Wk 1Person 10
Wk 1Person 10
Wk 1Person 2
Wk 1Person 2
Wk 1Person 3
Wk 1Person 3
Wk 1Person 4
Wk 1Person 4
Wk 1Person 5
Wk 1Person 5
Wk 1Person 6
Wk 1Person 6
Wk 1Person 7
Wk 1Person 7
Wk 1Person 8
Wk 1Person 8
Wk 1Person 9
Wk 1Person 9
Wk 1Person 1
Wk 1Person 1
Wk 1Person 10
Wk 1Person 10
Wk 1Person 3
Wk 1Person 4
Wk 1Person 4
Wk 1Person 5
Wk 1Person 5
Wk 1Person 6
Wk 1Person 6
Wk 1Person 7
Wk 1Person 7
Wk 1Person 8
Wk 1Person 8
Wk 1Person 9
Wk 2Person 1
Wk 2Person 1
Wk 2Person 10
Wk 2Person 10
Wk 2Person 3
Wk 2Person 3
Wk 2Person 4
Wk 2Person 4
Wk 2Person 5
Wk 2Person 5
Wk 2Person 6
Wk 2Person 6
Wk 2Person 7
Wk 2Person 8
Wk 2Person 8
Wk 2Person 9
Wk 2Person 9
Wk 2Person 1
Wk 2Person 1
Wk 2Person 10
Wk 2Person 10
Wk 2Person 2
Wk 2Person 3
Wk 2Person 3
Wk 2Person 4
Wk 2Person 5
Wk 2Person 5
Wk 2Person 6
Wk 2Person 7
Wk 2Person 7
Wk 2Person 8
Wk 2Person 8
Wk 2Person 9
Wk 2Person 9
Wk 2Person 1
Wk 2Person 1
Wk 2Person 10
Wk 2Person 10
Wk 2Person 2
Wk 2Person 2
Wk 2Person 3
Wk 2Person 3
Wk 2Person 4
Wk 2Person 4
Wk 2Person 5
Wk 2Person 6
Wk 2Person 6
Wk 2Person 7
Wk 2Person 7
Wk 2Person 8
Wk 2Person 8
Wk 2Person 9
Wk 2Person 9
Wk 2Person 1
Wk 2Person 1
Wk 2Person 10
Wk 2Person 10
Wk 2Person 2
Wk 2Person 2
Wk 2Person 3
Wk 2Person 5
Wk 2Person 5
Wk 2Person 6
Wk 2Person 6
Wk 2Person 7
Wk 2Person 7
Wk 2Person 8
Wk 2Person 9
Wk 2Person 9
Wk 3Person 1
Wk 3Person 1
Wk 3Person 10
Wk 3Person 10
Wk 3Person 2
Wk 3Person 2
Wk 3Person 3
Wk 3Person 4
Wk 3Person 4
Wk 3Person 5
Wk 3Person 5
Wk 3Person 6
Wk 3Person 6
Wk 3Person 7
Wk 3Person 7
Wk 3Person 8
Wk 3Person 8
Wk 3Person 9
Wk 3Person 9
Wk 3Person 1
Wk 3Person 1
Wk 3Person 10
Wk 3Person 10
Wk 3Person 3
Wk 3Person 3
Wk 3Person 4
Wk 3Person 4
Wk 3Person 5
Wk 3Person 5
Wk 3Person 6
Wk 3Person 6
Wk 3Person 7
Wk 3Person 7
Wk 3Person 8
Wk 3Person 8
Wk 3Person 9
Wk 3Person 9
Wk 3Person 1
Wk 3Person 1
Wk 3Person 10
Wk 3Person 10
Wk 3Person 2
Wk 3Person 2
Wk 3Person 3
Wk 3Person 3
Wk 3Person 4
Wk 3Person 4
Wk 3Person 5
Wk 3Person 5
Wk 3Person 6
Wk 3Person 6
Wk 3Person 7
Wk 3Person 7
Wk 3Person 8
Wk 3Person 8
Wk 3Person 9
Wk 3Person 9
Wk 3Person 1
Wk 3Person 10
Wk 3Person 10
Wk 3Person 2
Wk 3Person 2
Wk 3Person 3
Wk 3Person 3
Wk 3Person 5
Wk 3Person 7
Wk 3Person 7
Wk 3Person 8
Wk 3Person 8
Wk 3Person 9
Wk 3Person 9
Wk 4Person 1
Wk 4Person 1
Wk 4Person 10
Wk 4Person 2
Wk 4Person 2
Wk 4Person 3
Wk 4Person 3
Wk 4Person 4
Wk 4Person 4
Wk 4Person 5
Wk 4Person 5
Wk 4Person 6
Wk 4Person 6
Wk 4Person 7
Wk 4Person 7
Wk 4Person 8
Wk 4Person 8
Wk 4Person 9
Wk 4Person 1
Wk 4Person 1
Wk 4Person 10
Wk 4Person 10
Wk 4Person 3
Wk 4Person 4
Wk 4Person 5
Wk 4Person 5
Wk 4Person 6
Wk 4Person 7
Wk 4Person 9
Wk 4Person 9
Wk 4Person 1
Wk 4Person 1
Wk 4Person 2
Wk 4Person 2
Wk 4Person 4
Wk 4Person 4
Wk 4Person 5
Wk 4Person 6
Wk 4Person 7
Wk 4Person 8
Wk 4Person 8
Wk 4Person 2
Wk 4Person 3
Wk 4Person 3
Wk 4Person 4
Wk 4Person 4
Wk 4Person 5
Wk 4Person 5
Wk 4Person 6
Wk 4Person 6
Wk 4Person 7
Wk 4Person 7
Wk 4Person 8
Wk 4Person 8
Wk 5Person 9
Wk 5Person 9
Wk 6Person 1
Wk 6Person 1
Wk 6Person 10
Wk 6Person 10
Wk 6Person 2
Wk 6Person 2
Wk 6Person 3
Wk 6Person 3
Wk 6Person 4
Wk 6Person 4
Wk 6Person 5
Wk 6Person 5
Wk 6Person 6
Wk 6Person 6
Wk 6Person 7
Wk 6Person 7
Wk 6Person 8
Wk 6Person 9
Wk 6Person 9
Wk 6Person 1
Wk 6Person 1
Wk 6Person 10
Wk 6Person 10
Wk 6Person 2
Wk 6Person 3
Wk 6Person 3
Wk 6Person 4
Wk 6Person 4
Wk 6Person 5
Wk 6Person 5
Wk 6Person 6
Wk 6Person 6
Wk 6Person 7
Wk 6Person 7
Wk 6Person 8
Wk 6Person 8
Wk 6Person 9
Wk 6Person 1
Wk 6Person 1
Wk 6Person 10
Wk 6Person 10
Wk 6Person 2
Wk 6Person 2
Wk 6Person 3
Wk 6Person 3
Wk 6Person 4
Wk 6Person 4
Wk 6Person 5
Wk 6Person 5
Wk 6Person 6
Wk 6Person 6
Wk 6Person 7
Wk 6Person 7
Wk 6Person 8
Wk 6Person 8
Wk 6Person 9
Wk 6Person 9
Wk 6Person 1
Wk 6Person 1
Wk 6Person 10
Wk 6Person 10
Wk 6Person 2
Wk 6Person 2
Wk 6Person 3
Wk 6Person 3
Wk 6Person 4
Wk 6Person 5
Wk 6Person 5
Wk 6Person 6
Wk 6Person 7
Wk 6Person 7
Wk 6Person 8
Wk 6Person 9
Wk 6Person 9

<tbody>
[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1300[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1200[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]400[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]100[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1300[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1300[/TD]

[TD="class: xl65, align: right"]06/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2900[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]07/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]5000[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4900[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4300[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]5900[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]5600[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4600[/TD]

[TD="class: xl65, align: right"]09/06/2016[/TD]

[TD="align: right"]4300[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3000[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3000[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3000[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]2700[/TD]

[TD="class: xl65, align: right"]10/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]13/06/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]5600[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]5300[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4900[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4600[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4900[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]6500[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]6200[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4800[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4500[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]14/06/2016[/TD]

[TD="align: right"]4900[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]16/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]6000[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5700[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5900[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5600[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5100[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]6000[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5700[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5800[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5500[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5700[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5400[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5700[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]6100[/TD]

[TD="class: xl65, align: right"]17/06/2016[/TD]

[TD="align: right"]5800[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1900[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1600[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]20/06/2016[/TD]

[TD="align: right"]1800[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]5500[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4800[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4500[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]6000[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]5700[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4500[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]5000[/TD]

[TD="class: xl65, align: right"]21/06/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2900[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3000[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]23/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3100[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]24/06/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1500[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1200[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2000[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1700[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]1400[/TD]

[TD="class: xl65, align: right"]27/06/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]4800[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]4500[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]5000[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]28/06/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]30/06/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]6000[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5500[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]6400[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]6100[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5500[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5900[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5600[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]6200[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]5900[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]01/07/2016[/TD]

[TD="align: right"]3000[/TD]

[TD="class: xl65, align: right"]07/07/2016[/TD]

[TD="align: right"]2900[/TD]

[TD="class: xl65, align: right"]07/07/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2900[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]1000[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]700[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]900[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]900[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2100[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]1100[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]800[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]900[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]600[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]800[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2800[/TD]

[TD="class: xl65, align: right"]11/07/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5400[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5100[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5100[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4200[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]3900[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5900[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5600[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5200[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4900[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4800[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4500[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5300[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]5000[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4700[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]12/07/2016[/TD]

[TD="align: right"]6100[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2700[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2700[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2400[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2500[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2200[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2600[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]2300[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]14/07/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3800[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]4000[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3200[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]2900[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]4400[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3700[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3400[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3600[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3300[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3500[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]4100[/TD]

[TD="class: xl65, align: right"]15/07/2016[/TD]

[TD="align: right"]3800[/TD]

</tbody>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Welcome to the board :)

For future reference, we only need a small representative sample of what you are working with, not a big long list of data :)

having said that, here is how I would handle this. I only show a small portion of your sample, so adjust my ranges as needed...
[Table="width:, class:grid"][tr][td] [/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][td]
I​
[/td][td]
J​
[/td][/tr]
[tr][td]
1​
[/td][td]Week[/td][td]Date[/td][td]Person[/td][td]Sales Value[/td][td][/td][td][/td][td]Person 1[/td][td]Person 2[/td][td]Person 3[/td][td]Person 4[/td][/tr]

[tr][td]
2​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 2[/td][td]
6000​
[/td][td][/td][td]
7/9/2016​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][/tr]

[tr][td]
3​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 3[/td][td]
5500​
[/td][td][/td][td]
7/10/2016​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][/tr]

[tr][td]
4​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 3[/td][td]
5200​
[/td][td][/td][td]
7/11/2016​
[/td][td]
5500​
[/td][td]
1500​
[/td][td]
1500​
[/td][td]
4900​
[/td][/tr]

[tr][td]
5​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 4[/td][td]
6400​
[/td][td][/td][td]
7/12/2016​
[/td][td]
10500​
[/td][td]
5100​
[/td][td]
8100​
[/td][td]
11500​
[/td][/tr]

[tr][td]
6​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 4[/td][td]
6100​
[/td][td][/td][td]
7/13/2016​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][td]
0​
[/td][/tr]

[tr][td]
7​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 5[/td][td]
5500​
[/td][td][/td][td]
7/14/2016​
[/td][td]
7700​
[/td][td]
5100​
[/td][td]
4700​
[/td][td]
7100​
[/td][/tr]

[tr][td]
8​
[/td][td]Wk 4[/td][td]
7/1/2016​
[/td][td]Person 5[/td][td]
5200​
[/td][td][/td][td]
7/15/2016​
[/td][td]
6900​
[/td][td]
7700​
[/td][td]
6100​
[/td][td]
4400​
[/td][/tr]
[/table]

F8=your start date
G2=SUMIFS($D:$D,$B:$B,$F2,$C:$C,G$1)
copied down and across as needed
 
Upvote 0
Thanks for that reply and the advice.

I see and understand how you've done that. However I was hoping to do it with a measure in PowerPivot, and I am looking to get a rolling average so that as data is collected over time I always get the average of the daily totals for the previous seven days. Or in the future the previous seven days according to a date selected on a slicer.

Thanks.

G
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Power bi Calculate the Monday dates
Replies
1
Views
124
GraH
GraH
A
  • Solved
help required with complex (well, i think so) statement in power query
Replies
3
Views
292
ajm
A
N
  • Question Question
Calculating hours of working beetween start and end time but when end tim is on other row then start time and on that row has midnight as end time ?
Replies
0
Views
367
nunizgb
N
J
  • Question Question
Adding stock market data from yahoo finance to master Excel file
Replies
3
Views
1K
kcmuppet
K
S
  • Solved
Customized running total in Excel power query
2
Replies
11
Views
441
JGordon11
JGordon11

Forum statistics

Threads
1,223,248
Messages
6,171,021
Members
452,374
Latest member
keccles

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top