Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
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: excelcampus.com/powerquery/power-query-date-errors-settings
Related Videos:
Convert Text to Time Values with Power Query: youtube.com/watch?v=1h94nq4if28
How to Install Power Query in Excel 2010 or 2013 for Windows: youtube.com/watch?v=gwW2CDdvUUs
How to Unpivot Data with Power Query in Excel: youtube.com/watch?v=Kbu5RkUo6-k
Preview of PowerQuery, Pivot Tables, and Dashboards Video Series:
youtube.com/watch?v=WYfIgthJjFE
#MsExcel #ExcelCampus
00:00 Introduction
00:57 Local Settings
02:16 Regional Setting
04:30 Changing Regional Settings
06:40 Convert Dates
- 4 Ways To Fix Your Power Query Date Errors Locale ( Download)
- The Ultimate Guide to Fixing Your Power Query Date Errors ( Download)
- Changing Date Formats in Power BI | Power Query Editor Date Error ( Download)
- How to Fix Power Query Date Error ( Download)
- PowerQuery Locale for dates not working ( Download)
- 4 Ways to Fix DATEFORMAT ERROR in Power BI Desktop // Beginners Guide to Power BI in 2021 ( Download)
- Fix Date error in Power Query Table in Power BI ( Download)
- The most common data type error in Power Query: Using a Locale ( Download)
- Easily Fix Dates Formatted as Text with Power Query ( Download)
- Unable to Change Date Format in PowerBI Watch this | PowerBI Tutorial | MI tutorials ( Download)
- Unable to Fix Date Format in Power BI or Excel Watch this | Text-to-Date Conversion | MiTutorials ( Download)
- Power Query is not Converting Dates using Locale Setting, Don't worry Here is the Solution... ( Download)
- Solving 5 date error in power query ( Download)
- How To Correct Errors On Date Data Type In Power Query ( Download)
- 25 - Using Locale to Manage Dates in Power Query ( Download)
