Calculating a Value By Taking Averages of current and previous months?

[kiotsuresh]

Hi ,

I Have Data Like below,

Item	Month	Name	Value
Chair	Dec - 2021	Balance	100
Chair	Jan -2022	Balance	200

I need to calculate the number as average of current and prev month value, for jan 2022 (100+200/2=150) and same for all the available months. and I need to give a new name to that value as "Average Balance"

Output would be

item	Month	Name	Value
Chair	Dec - 2021	Average Balance	100
Chair	Jan -2022	Average Balance	150

How to Achieve this using Alteryx. the data I'm Handling has lot of years data where this logic should work for all the months and year.

[DenisZ]

Please find attached workflow

Hope it helps