Create Date from Another Date Column in Query Editor

[Anonymous]

So I'm not very good with M code in the Query Editor. I have a column that has the end of month date. I want to use the month and year from this column to create another column but make the day the 15th instead. 

My attempt was below but it doesn't work:

Date.Month([End of Source Month]) & "/15/" & Date.Year([End of Source Month])

[Greg_Deckler · Accepted solution]

Perhaps:

= Table.AddColumn(#"Changed Type", "Custom", each Date.FromText(Text.From(Date.Month([Date])) & "/15/" &  Text.From(Date.Year([Date]))))

[Interkoubess]

Hi @Anonymous,

Try this formula ( #duration function )

[End of Source Month]+#duration (14,0,0,0)

Hope it helps...

Ninter