How would I get to 1 month after the Last day of last year in Power Query M?

[thegusman]

I'm trying to get to January 31st of the current year.

Im using this formula to get to the end of last year

Date.EndOfYear(Date.AddYears(DateTime.Date(DateTime.LocalNow()),-1)

How would I add on the additional 31 days?

[fhill]

Other thought..?  If you are looking for exactly the end of January each year (and January always has 31 days, and it's not a leap year factor), why not just hard code the Day and Month, then you only have to calcualte the year?

= #date(Date.Year(DateTime.LocalNow()),1,31)

[littlemojopuppy]

Date.AddMonths([DateField], 1)

[amitchandak · Accepted solution]

@thegusman , Try like

Date.AddMonths( Date.AddYears(Date.EndOfYear(DateTime.Date(DateTime.LocalNow())),-1),1)