Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Helper III
4 years ago
Solved

Date Error

Hi community, 

 

I'm getting this following error in my Date columns, 

Can anyone please help me out as I've encountered this Error for the first time.

 In Dates Column I'm getting this Error,

 

And in Datetime and Custom column I'm getting the following Error : 

 

Expression.Error: We cannot convert the value #date(2021, 11, 11) to type Number.
Details:
Value=11/11/2021
Type=[Type]

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hey, 

    To avoid this issue, change regional settings of Power BI Dekstop

    Alternatively, you can just do it in PowerQuery. Change type using Locale 

    It's impoprtant to fist let Power Query  identify correctly date and then proceed with further transformations.
    E.g. if you have Date/Time, then first change it with Locale to Date/Time format and only then to Date 

    Hope this helps

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Niraj_vora0106 , Can you check the data, I think there are different formats of date which is not working.

    Also, check it before the first time the change data type is applied 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, Niraj_vora0106 

     

    The problem is what's your original data format. Normal date formats don't go wrong. Can you show it so we can help you fix it?

     

    Best Regards,
    Community Support Team _ Janey

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey, 

    To avoid this issue, change regional settings of Power BI Dekstop

    Alternatively, you can just do it in PowerQuery. Change type using Locale 

    It's impoprtant to fist let Power Query  identify correctly date and then proceed with further transformations.
    E.g. if you have Date/Time, then first change it with Locale to Date/Time format and only then to Date 

    Hope this helps