Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Error when converting text to date

Hi There,

 

I have four columns containing dates in this format that are by default read as text:

 

 

When i try to change the data type into date unfortunately power bi delivers many errors:

 

I also tried analyzing these errors, such as: 

The text says: "It was not possibile analyzing the specified input as Date value"

 

How can i solve this?

 

Thanks!

  • Looks like the default date format / regional settings don't agree with the format of the data . for example 17/06/2021 or 06/17/2021

    This is quite common.  Decide which one is correct and either change the date settings in powerbi or use the power query Change Type->using locale

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Looks like the default date format / regional settings don't agree with the format of the data . for example 17/06/2021 or 06/17/2021

    This is quite common.  Decide which one is correct and either change the date settings in powerbi or use the power query Change Type->using locale

    • Anonymous's avatar
      Anonymous
      Not applicable

      Works like a charm using the local date settings, THANKS A LOT!!