Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
Learn how to fix date errors in Power Query. The video covers four different ways including:
1. Adjusting the locale for individual columns.
2. Changing the regional settings for the entire file.
3. Changing the regional settings on your operating system.
4. Using the “Columns From Examples” feature to decipher the correct formatting and apply it to your query.

If you’d like to read the corresponding blog post for this video on my website, you can find it here: https://www.excelcampus.com/powerquer...

Related Videos:

Convert Text to Time Values with Power Query:    • Convert Text to Time Values with Powe...  

How to Install Power Query in Excel 2010 or 2013 for Windows:    • How To Install Power Query For Excel ...  

How to Unpivot Data with Power Query in Excel:    • How to Unpivot Data with Power Query ...  

Preview of PowerQuery, Pivot Tables, and Dashboards Video Series:
   • Preview of PowerQuery, Pivot Tables, ...  

#MsExcel #ExcelCampus
00:00 Introduction
00:57 Local Settings
02:16 Regional Setting
04:30 Changing Regional Settings
06:40 Convert Dates