Average of same month rows

[karla_camacho]

Hello community!
Reaching out for your help:

I´m trying to re-apply this Excel formula in Alteryx:

As you can see I need to create a column that for each period calculates the average of the column at the left of it but only for the values that are in the same month.

For example:

If the period has the month January, the value in column H will be the average of all the other values in column G that also occur in the month January, if we have 2 years we have 2 Januaries, In this case we have 10 years of data, that´s why there are 10 values that we need to calculate the average for.

Please help!!

[FrederikE]

Hey @karla_camacho,

1. Split the Date into Months only.

2. Use a Summarize with "Group By Month" and Average of your Value. 

[Emmanuel_G · Accepted solution]

@karla_camacho 

Find in attachement the way of achieving that.

I did a test with dummy sample of your dataset.