Fix Messy Dates in Power Query in 10 Minutes | M Code Tutorial
🎯 Learn how to transform messy date formats in Power Query using M code!
In this 10-minute tutorial, I'll show you how to handle:
✅ Different date formats (MM/DD/YYYY, DD/MM/YYYY, YYYY.MM.DD)
✅ Text dates that need conversion
✅ Error handling with ##### symbols
✅ The exact M code you need
⏱️ TIMESTAMPS:
0:00 - Intro: The messy date problem
0:45 - Understanding the data issues
2:15 - Writing M code for date transformation
5:30 - Handling multiple date formats
8:00 - Testing and error handling
9:30 - Final results
📥 DOWNLOAD THE SAMPLE FILE: https://github.com/Racheal253/PowerQu...
💻 M CODE FROM VIDEO:
try Date.From([DeliveryDate], "en-US")
otherwise try Date.From([DeliveryDate], "en-GB")
otherwise try Date.FromText(Text.From([DeliveryDate]), [Format="yyyyMMdd"])
otherwise try Date.FromText(Text.From([DeliveryDate]), [Format="yyyy.MM.dd"])
otherwise null
🔔 Subscribe for more Power Query tutorials!
#PowerQuery #Excel #DataCleaning #MCode #ExcelTutorial
---
Related searches: power query dates, m language tutorial, clean dates excel, power query transform dates, excel date formatting