Transform Date Column

[xcvxcv]

Hello,

do some one know how to transform Dates?

I have a column with the ends of all Months per year:

End of the month date
31.01.2019
28.02.2019
30.03.2019
etc...

Question: How can I transform this column. I want that all of this dates only the days are changing to 14. this:

14.01.2019
14.02.2019
14.03.2019
etc.

Are their a function for this available?

 

[xcvxcv]

With PowerQuery

 

[sandy666]

change type to text
Extract after first delimiter
add prefix 14.
change type to date

all you can do on Transform tab