The Ultimate Guide to Fixing Your Power Query Date Errors
Learn how to fix date errors in Power Query when you try to convert a column to a date format. This video covers:
1. Adjusting the Regional Settings Using Locale for Individual Columns.
2. Adjusting the Regional Settings Using Query Options.
3. Using the “Columns From Examples” feature to decipher the correct formatting and apply it to your query.
Please download the practice example here: https://docs.google.com/spreadsheets/...
Timestamps:
00:00 The Reason for Date Errors in Power Query
00:26 The Source Data
00:57 Where to Find Your Regional Settings
01:47 Adjusting the Regional Settings Using Locale
05:12 Adjusting the Regional Settings Using Query Options
07:27 Using “Columns From Examples”
☕ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :), it's really quick and easy, please use this link: https://www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe: / @missmicrosoft
✅ For more Power Query videos please use the links below:
Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: The Ultimate Beginner...
Combine Data from Multiple Sheets into One Sheet in Excel: • Easiest Way to Combine Data from Multiple ...