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!
Solved! Go to Solution.
That's what I thought so too and for some weird reason it didn't work before - now it works!
Thanks so much again!!!!
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 .