Error in Date column

[Anonymous]

new with powerBI,I get data fm excel file n theres an "error" in the date column..how to rectify this issue,any help will do,tks..

[Jimmy801 · Accepted solution]

Hello @Anonymous 

If in the Excel-file the date-field is formated as date, you should normaly get no errors. In your case this might not be the case. Therefore you need to check the date type (american, english) and not applying a Table.TransformColumnTypes but a Table.TransformColumns instead using a Date.From(_, culture) Function. But without any Query/data I'm not able to help you further.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[edhans · Accepted solution]

You can approach this a few ways:

1. Fix the dates in your source.
2. Try converting the "date" to a real date. The Date.From or Date.FromText functions may help, and you can wrap them in a try/otherwise statement. So:

try Date.FromText([DateField]) otherwise null

That will try to convert the date-looking-thing in the DateField from text to a date. If it works, great. If not it returns null, which isn't an error.

If you need further help, please post sample data as text so we aren't guessing what your "dates" look like or what the errors are.

[Jimmy801 · Accepted solution]

Hello @Anonymous 

If in the Excel-file the date-field is formated as date, you should normaly get no errors. In your case this might not be the case. Therefore you need to check the date type (american, english) and not applying a Table.TransformColumnTypes but a Table.TransformColumns instead using a Date.From(_, culture) Function. But without any Query/data I'm not able to help you further.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

tks for the help..greatly appreciated