Forum Discussion
Solved
Average by Week
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 Pe...
morgancampbell , Please try a new column like
Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])
morgancampbell , Please try a new column like
Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])
Ah it worked!!
That's brilliant, thank you
