Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Solved! Go to 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
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
The issue has been solved, in Power Query there was Calculation error.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |