Hey guys, Hope someone might be able to help,
Ive got a Data Table
Date - Difference - Month - Year
Date = Just a normal set of Dates
Difference = Just some numbers
Month = set to =MONTH([@Date]) (so a range of 1s to 12's)
Year = set to =YEAR([@Date]) (So just some years from the available data
For context I have data monthly going back to 2000
What im trying to do is then setup some formulas so that it can average all Jan,Feb etc
=AVERAGEIFS(Table1[Difference],Table1[Month Count],EN9,Table1[Year],">="&$EP$6)
EP6 = 2006 (as I only want to average values since whatever year I put in that cell)
EN9 = 1 (so January)
I just think that ive added Month and Year when I should be able to just put it into the formula directly and not need the additional two col's
Basically I think i need something like month(Table1[date] but im just not sure of the syntax and Ive looked online and couldnt find anything...
Any advice?
Ive got a Data Table
Date - Difference - Month - Year
Date = Just a normal set of Dates
Difference = Just some numbers
Month = set to =MONTH([@Date]) (so a range of 1s to 12's)
Year = set to =YEAR([@Date]) (So just some years from the available data
For context I have data monthly going back to 2000
What im trying to do is then setup some formulas so that it can average all Jan,Feb etc
=AVERAGEIFS(Table1[Difference],Table1[Month Count],EN9,Table1[Year],">="&$EP$6)
EP6 = 2006 (as I only want to average values since whatever year I put in that cell)
EN9 = 1 (so January)
I just think that ive added Month and Year when I should be able to just put it into the formula directly and not need the additional two col's
Basically I think i need something like month(Table1[date] but im just not sure of the syntax and Ive looked online and couldnt find anything...
Any advice?
