Average by Week

[morgancampbell]

My Data is as  follows, with data going back to the start of the year

Week	Week Start Date	Name	Emails Sent
38	14/09/20	Person 1	150
38	14/09/20	Person 2	256
38	14/09/20	Person 3	189
37	07/09/20	Person 1	354
37	07/09/20	Person 2	156
37	07/09/20	Person 3	345

And I'm looking to create another column of the average emails sent per week, so it would look like the below:

Week	Week Start Date	Name	Emails Sent	Emails Sent (Weekly Average)
38	14/09/20	Person 1	150	198
38	14/09/20	Person 2	256	198
38	14/09/20	Person 3	189	198
37	07/09/20	Person 1	354	285
37	07/09/20	Person 2	156	285
37	07/09/20	Person 3	345	285

So my question is, how do I create a column which can do this?

[amitchandak · Accepted solution]

@morgancampbell , Please try a new column like

Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])

[morgancampbell]

Ah it worked!!

That's brilliant, thank you