how i change date year for all rows for date column from 1997 to 2019

[arehman]

i try to replace value 1997 to date column but it change only one row value how i change all rows 1997 year to 2019 using power bi see screen shot

[arehman]

i got solution by first changing date column type to text and than in tranform select replace option and replace value 1997 to 2019 with selecting advance option " non-breaking space " and replace 1997 to 2019 and after full replacement change date column type to date see screen shot hope it will help you too 

change year value in column in power bi by arehman

[mahoneypat]

Add a custom column with this formula

=#date(2019, Date.Month([Date]), Date.Day([Date]))

Then delete your original column.

[arehman]

this does not work shows error