Date Error

[Niraj_vora0106]

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]

[Anonymous · Accepted solution]

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

[v-janeyg-msft]

Hi, @Niraj_vora0106 

Has the problem been solved? I've been waiting for your reply to follow up.

[Niraj_vora0106]

Hi @v-janeyg-msft 

The issue has been solved, in Power Query there was Calculation error.

[v-janeyg-msft]

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

[amitchandak]

@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