Forum Discussion
morgancampbell
Helper I
Helper IAverage 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])
amitchandak
Super User
Super Usermorgancampbell , Please try a new column like
Averagex(filter(Table,[Week Start Date] =earlier([Week Start Date])),[Emails Sent])
morgancampbellHelper I
Helper IAh it worked!!
That's brilliant, thank you