Forum Discussion

Sheref_Morad's avatar
Sheref_Morad
Frequent Visitor
4 years ago
Solved

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  
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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}})

     

mh2587's avatar
mh2587
Super User
4 years ago

Just click on 123 with the year and convert the type to date

  • Sheref_Morad's avatar
    Sheref_Morad
    Frequent Visitor
    4 years ago

    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

    • PC2790's avatar
      PC2790
      Community Champion
      4 years ago

      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

       

      • Sheref_Morad's avatar
        Sheref_Morad
        Frequent Visitor
        4 years ago

        Thank you for Answering , it converted into irrelvant Date so i can't make the year data that was given in the source data