Derive Year from Datetime field

Question

Hi AllI 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 :&nbsp;The formula I used to derive&nbsp; the year is :&nbsp;New Column -&gt;&nbsp;year('Table'[Installation DateTime])&nbsp;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:&nbsp;Derived YearCan someone please help on resolving this?Note: I would require this in Timeseries as I will be using this for forecasting.ThanksPoojitha&nbsp;&nbsp;

v-xicai · Accepted Answer

Hi Anonymous&nbsp;,&nbsp;You can change the data type of the Year column to Whole Number.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards,Amy&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Derive Year from Datetime field

2 Replies

Related content

Could a Derived DateTime Partition Column Affect Incremental Refresh Performance?

Get Time from DateTime field

FORMAT DATETIME Field spark sql notebook cell

Error in Power Query combining overlapping start end datetime fields

Converting Epoch Datetime into regular datetime format