EOMONTH equivalent in M

[Anonymous]

Is there an equivalent of EOMONTH function in Power Query?

Or is there a work around to calculate end of month of a date for next month, and for previous month?

I'll highly appreciate some help.

[Anonymous · Accepted solution]

ok so it will be

Date.EndOfMonth(Date.AddMonths([Date],1))

[watkinnc · Accepted solution]

You could do:

LoadDate = Table.AddColumn(LastStepName, "NewColumnName", each Date.EndOfMonth(Date.AddMonths([Column2]{0}, 1))

This will increment the date by one month, and then get that end of month date.

--Nate

[watkinnc]

Yes, it's Date.EndOfMonth(DateOrDateColumn), which returns the last date in the month for each date.

--Nate

[Anonymous]

eomonth(date,1) gives next month's end date. How would we do that in M?

[Anonymous · Accepted solution]

ok so it will be

Date.EndOfMonth(Date.AddMonths([Date],1))