Forum Discussion
Previous Month from a Date Column in Query Editor
So I have to do this in Query Editor. I have a date column that has various dates like 2/1/16, 3/3/16, 4/2/16, etc.. I need to create a column with a date that is the last day of the previous month b...
Anonymous,
You can add a custom column and paste in the following code:
=Date.EndOfMonth(Date.AddMonths(DateColumn, -1))
Anonymous,
You can add a custom column and paste in the following code:
=Date.EndOfMonth(Date.AddMonths(DateColumn, -1))
Anonymous Easy enough! Thanks for the help!
Easy and nice, no techincal debt
