I have a column of years, months and a column of temperature of every month
I need to make the avarage between the same month of diferents years
The avarage of all the Januarys, Februarys.....
@Askquestioncan you share a sample data and the expected output ?
Month | Temperature
Jan/20 | 10
Fev/20 | 15
Jan/21 | 20
Fev/21 | 25
Month | Temperature | Month Avarage
Jan/20 | 10 | 15
Fev/20 | 15 | 20
Jan/21 | 20 | 15
Fev/21 | 25 | 20
Date#(Month, 'MMM/YYYY') as MonthYear
,Month(Date#(Month, 'MMM/YYYY')) as Month
load * inline [
left join (data)
avg(Temperature) as Month_Average
group by Month;
Very thank you it worked!
But there's a problem I forgot to say
I have 2 diferents cities and I need to calculate their months saparely with this method it made the avarage of both how can I fix it?