Power Query Merge in Power BI with No Exact Match 🤯 (The "Range" Merge)

Опубликовано: 20 Август 2024
на канале: Avi Singh - PowerBIPro

1,108

💬 Comment "Self Merge" to get my Self Merge Tutorial
👉 Get My Full Power BI Training Program https://www.LearnPowerBI.com/training
➔ Need Free Help? Just Message me on LinkedIn / powerbipro
===============
Every Power BI Beginner should learn three kinds of Power Query Merges in Power BI:
#1 The Regular Merge: This most beginners learn fairly quickly
#2 The "Range" Merge: Where there is no exact match between columns, instead a Value needs to be compared to a Range. This video covers the "Range" Merge
#3 The Self-Merge: The Self-Merge would be covered in a future video. Comment below if you would like me to send you an early copy of the Self-Merge Tutorial

==Topics Covered==
00:00 Introduction: Three Power Query Merges every Beginner Must Know
02:31 Meet Avi Singh, Power BI Pro
02:59 The "Range" Merge Problem
04:38 The Solution to "Range" Merge Problem
09:31 Build the Data Model after Loading Power Query

================================
#PowerBI #PowerBIHowTo #PowerBIPro

⚡Power On!⚡
-Avi Singh
http://www.LearnPowerBI.com
http://www.AviSing.com