Calculating Monthly Average for the below Data

Question

Hi

I have the data as attached for 5 year. I need to calculate Each month average. for example for Jan 2025 - The average should calculated by Dec'24+Jan'25/2 and for Feb'25 it should be Jan'25+Feb'25/2 and for all the years data it should calculate in this way

How to Acheive this through Alteryx? Can someone help me out it this?

Sample Data.xlsx

alexnajm · Accepted Answer

Summarize your data if you need to aggregate it down to fewer rows, Sort your data in order, then use a Multi-Row Formula tool to calculate the current row plus the row above divided by two! You can use the group by function within the multi-row tool as well if you need to keep the calculations within a group

dreldrel · Accepted Answer

Hey @Alteryxexpert, essentially you are talking about a moving average calculation. Here is a sample workflow demonstrating how to calculate the moving average. Make sure that rows where the value does not exist are set to NULL so they are excluded from the calculation.

IF IsNull([Row-1:Sum_Value]) THEN [Sum_Value] ELSE ([Sum_Value]+[Row-1:Sum_Value])/2 ENDIF