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.
Solved! Go to 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
You can approach this a few ways:
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can approach this a few ways:
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello @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
tks for the help..greatly appreciated
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.