Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

error date column

Hello PBI Community,   Anyone please help me with this error in date column. Also i tried splitting the column with delimiter and had errors. Can anyone help me with either of these errors.   I h...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    Remove your current Change Type step or convert the Date column to Text type first. Then right click on the Date column and select Change Type > Using Locale... In the Change Type window, select Date for Data Type, English (United Kingdom) or other locales which has the same date format as your original Date column input. This should change the type into Date correctly.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

Rotemshan's avatar
Rotemshan
Helper I
4 years ago

Hello, 

 

I'm experiencing the same problem, 

Unfortunately, the solution here didn't work, 

The data type is "text" but, when trying to change it to a date, or change it by locale, all become to be "errors"

I tried to:

  1. Split the column to date and time
  2. Replace the blank values with null/blank

Nothing seems to be working

Any Ideas? 

 

Before

 

After

 

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Rotemshan 

 

As your original column has both date and timestamps values, change its type to Date/Time instead of Date. When it is of Date/Time type, then you can change it to Date type without any errors. 

 

Best Regards,
Community Support Team _ Jing

  • Rotemshan's avatar
    Rotemshan
    Helper I
    4 years ago

    Hi v-jingzhang 

    I tried the suggested but unfortunately, still getting the same error 

     

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      4 years ago

      Rotemshan Can you share the error message?

      • Rotemshan's avatar
        Rotemshan
        Helper I
        4 years ago

        Eventually, I changed the source of the data to XLSX instead of CSV, it saves a lot of time transforming the data, 

        I'm not sure if this is the best practice, but it works. 

        Thank you very much