Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

We cannot convert the column automatically to Date Type

I have a date column with values as 2014-11-08 08:58:30.3 format. I am trying to convert the value as 2014/11/08 because i need to use Power bi custom Timeline slicer and it takes date in this format. When I am trying to change the Format under Modelling tab for the column, i am getting the error on We cannot convert the column automatically to Date Type

Can anyone give me steps how to approach to my solution. I have date for different years. Thanks

Data Modeling
  • McCow's avatar
    McCow
    8 years ago

    Hi Anonymous

    you can try convert the data column manual, as text field in Query Mode like this

     First split column, then convert. If you don't need a time - remove it at last.

     

    And HERE is full example

     

    You can see, yours text date field was correct converted to DATE

     

    Best regs

6 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Please do it in the Query Editor. 

    We_cannot_convert_the_column_automatically_to_Date_Type2We_cannot_convert_the_column_automatically_to_Date_Type

     

    Best Regards,

    Dale

    • McCow's avatar
      McCow
      Resolver III
      8 years ago

      Hi Anonymous

      you can try convert the data column manual, as text field in Query Mode like this

       First split column, then convert. If you don't need a time - remove it at last.

       

      And HERE is full example

       

      You can see, yours text date field was correct converted to DATE

       

      Best regs

      • prasa's avatar
        prasa
        Helper I
        8 years ago

        The link provided is broken.. Can you please update the link ?