Forum Discussion
Data Shaping
Hello!
I am working with an example database that in the fact table has a date column with years 1900, 1901 and 1902. How can I change the years of this date column to other years (for example 2005,2006 and 2007) in the Query Editor, maintaining the day and the month?
Hi Anonymous ,
This is my test table:
Please change data type from “Date” to “Text”.
Select Transform tab – Replace Values, enter the value you want to find and replace with.
Then you can change the year and maintain the day and the month.
Last, please remember to change data type from text to date.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , In power query you can use
Date.AddYears([Date], 205)
Use on new column of transform the same column
Hi Anonymous ,
This is my test table:
Please change data type from “Date” to “Text”.
Select Transform tab – Replace Values, enter the value you want to find and replace with.
Then you can change the year and maintain the day and the month.
Last, please remember to change data type from text to date.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
