Create a Join based on Date Range in Power Query

This video shows two methods to create a join between tables based on a range of dates. You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 CONTENTS 00:00 Introduction 01:16 Data 01:55 Method 1: Date range join 08:21 Method 2: Explode dates WRITTEN ARTICLE: https://gorilla.bi/power-query/join-on-date-range/ 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! #Join #powerquery #bigorilla