Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 20...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    4 years ago

    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.

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you very much for the detailed solution.