Can I replace a date in a column in Power Query - Last day of Month plus 1

[TrevorBoat]

Hi,

Can I replace a date in a column in Power Query - Last day of Month plus 1or the first day of the next month?

I tried to do this with replace values:

= Table.ReplaceValue(#"Removed Columns",#date(Date.EndOfMonth),Date.EndOfMonth +1,Replacer.ReplaceValue,{"_date"})

Thanks!

[TheoC · Accepted solution]

Hi @TrevorBoat 

In Power Query, go to Add Column tab, then click on Custom Column.  Add the below formula:

= Date.AddDays ( Date.EndOfMonth ( [Date Column] ) , 1 )

The output will be the Green column.  Make sure that you change the new custom column (i.e. in my example "End of Month + 1") to Date type.

Hope this helps!

Theo 🙂