Dynamic average in new column

[serhoshu1118]

How do I create a new column that is the average of the two previous columns that are dynamically updated? 

For example, please see the attached screenshot, On Excel, as each month's data is updated, I want the "MoM" to be the average of the two most recent months. So if I add July-17, the MoM column will become the average of June and July instead of May and June. Is there a way to replicate this on Alteryx? Thanks! 

[mborriero · Accepted solution]

It is Jul-17 vs Jul-16? Have a try with this

[serhoshu1118]

That's what I thought so too and for some weird reason it didn't work before - now it works!

Thanks so much again!!!! 

[Suraj3]

Hi ,

Could you help me with dynamic averaging of date wise data where the dataset changes every day as a new date column gets added .