Extract Dates From Text Strings in Power Query
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/extrac...
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_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / 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