Forum Discussion
EOMONTH equivalent in M
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....
ok so it will be
Date.EndOfMonth(Date.AddMonths([Date],1))
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
eomonth(date,1) gives next month's end date. How would we do that in M?
ok so it will be
Date.EndOfMonth(Date.AddMonths([Date],1))