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: [ Ссылка ]
CONTENTS
00:00 Introduction
01:16 Data
01:55 Method 1: Date range join
08:21 Method 2: Explode dates
WRITTEN ARTICLE:
[ Ссылка ]
Master Functions and Syntax in M
[ Ссылка ]
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: [ Ссылка ]
SUBSCRIBE TO MY CHANNEL
[ Ссылка ]
LET'S CONNECT:
Blog: [ Ссылка ]
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]
Thank you for your support!
#Join #powerquery #bigorilla
Ещё видео!