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'>https://gorilla.bi/powerquery/joino...
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'>https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi'>https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#Join #powerquery #bigorilla