Forum Discussion
Date Column
I have a column in Power Query that has a several years period as a Whole Number, I want to transfer it to a date column
Hi Sheref_Morad ,
First, change the data type of Year Column to Text.
And now , again change the data type to Date, it'll work.
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",{{"Year", type text}}), #"Changed Type2" = Table.TransformColumnTypes(#"Changed Type1",{{"Year", type date}})
5 Replies
Hi Sheref_Morad ,
First, change the data type of Year Column to Text.
And now , again change the data type to Date, it'll work.
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",{{"Year", type text}}), #"Changed Type2" = Table.TransformColumnTypes(#"Changed Type1",{{"Year", type date}})Just click on 123 with the year and convert the type to date
Thanks for Answering, I did that several times and it transformed into irrelevant dates, I just want the number 2015 to be treated as year date
Step 1: Convert to date normally, power query code as below:
= Table.TransformColumnTypes(Table,{{"Year", type date}})Step 2: From Transform --> Date & Time Column --> Select Date -- Year as shown below:
Code as below:
= Table.TransformColumns(#"Changed Type",{{"Year", Date.Year, Int64.Type}})However it will convert the year as Whole number only as this is Power BI interprets the year but it should not hamper any of your reporting and calculations
