Data Shaping

[Anonymous]

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?

[v-yadongf-msft · Accepted solution]

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.

[Anonymous]

Thank you very much for the detailed solution.

[amitchandak]

@Anonymous , In power query you can use

Date.AddYears([Date], 205)

Use on new column of transform the same column