DAX: From today, Totals of each month 2,3,4,5, etc [Working on a forecast]

[DavidPVoss]

I am working on a forecast and am trying to calculate the totals for a month in the future and to consider the potential change of year

I have the following formula to calculate, from todays date, the totals of 3rd month from now:

M03 = CALCULATE(SUM('Activities'[AMOUNT]),FILTER('Activities',MONTH('Activities'[Date])= MONTH(TODAY())+3), YEAR('Activities'[Date])= YEAR(TODAY()))

The issue is when the 3rd month from today happens to fall in YR2023, then the result is attempting to show January 2022 (with Today being October)

Any suggestions would help

[Greg_Deckler]

@DavidPVoss I like to use EOMONTH in these kinds of situations. Handles year changes and things like leap years flawlessly.