Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change text data type to date data type

Hi,

I have fiscal Period column and I want to convert in to “Date” format.When  tried to change data type to “date” format It has created very weired number.

I do not have any DATE column in my dataset.

Thanks

Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    In Power Query, change the column type to Text.

    Add a column like this

    Text.Combine({[Fiscal Period], "01"})

    That just adds 01 to the end of the data.

    Change the new column type to Date

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    What is the error you are getting?

     

    You can try this after converting it to date:

    select the format of your date from this dropdown:

     

     

    let me know if this works.

     

    Thanks,

    Tejaswi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      When i have chaged Data Type to Date,I am getting below weird numbers,

      • HotChilli's avatar
        HotChilli
        Community Champion
        7 years ago

        In Power Query, change the column type to Text.

        Add a column like this

        Text.Combine({[Fiscal Period], "01"})

        That just adds 01 to the end of the data.

        Change the new column type to Date