Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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}})
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
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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
Thank you for Answering , it converted into irrelvant Date so i can't make the year data that was given in the source data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |