You want to retrieve a date from a text value but can’t get it to work? After this video you will know how to solve this for sure. The video shows how you can instruct Power Query the exact format of your date values so it can transform the value to a date.

WRITTEN BLOGPOST:
https://gorilla.bi/power-query/extract-date-from-text/

Master Functions and Syntax in M
https://powerquery.how

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

Website: https://gorilla.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_confirmation=1

LET’S CONNECT:
Blog: https://gorilla.bi
Facebook: https://facebook.com/BIGorilla/
Twitter: https://twitter.com/rickmaurinus
LinkedIn: https://linkedin.com/in/rickmaurinus/

Thank you for your support!

0:00 Introduction
0:36 Automatically Recognize Dates
1:46 Instruct Date Formatting
6:07 Include locale or Culture

#extractdates#powerquery #bigorilla

Please take the opportunity to connect and share this video with your friends and family if you find it useful.