Derive Year from Datetime field

[Anonymous]

Hi All

I have a requirement to derive Year field from a datetime field (Field name is Installation DateTime). The data of the datetime field looks likes below : 

The formula I used to derive  the year is : New Column -> year('Table'[Installation DateTime]) but the results looks wrong . All values are shown as 1905. Expected data is 2017,2018,2019 but all show as 1905,1905,1905. (Screenshot attached below)

Also what should be the datatype and format of the new column.

Data for Datetime Field:

Derived Year

Can someone please help on resolving this?

Note: I would require this in Timeseries as I will be using this for forecasting.

Thanks

Poojitha

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can change the data type of the Year column to Whole Number.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.