In this video I show you how to do a conditional join in Power Query. Instead of using the merge feature from the ribbon I use an alternative way of joining two tables and compare it to a normal merge.

Download file here datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powerbidesigntransformation

Power BI Essentials datatraining.io/powerbilearningpath

Business User Training datatraining.io/powerbi-business-users

For Custom Trainings and Consulting email directly support@datatraining.io

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
0:31 Example
1:22 Creating a list
03:07 Filtering a list using List.Select
5:36 Using a filtered list to perform a conditional join
7:00 Fuzzy Match instead of a conditional join
08:47 End

---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta instagram.com/howtopowerbi/
LinkedIn linkedin.com/in/basdohmen/
TikTok tiktok.com/@how.to.power.bi
X twitter.com/HowToPowerBI
fb facebook.com/groups/howtopowerbi
Threads threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos epidemicsound.com/referral/8pjcbj
🚀 For growing on YouTube: tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

• Conditional JOIN using Power Query | A different way of merging in Power BI ( Download)
• How to conditional merge tables in Power Query ( Download)
• Power BI Tutorial: Merge Queries in Power Query ( Download)
• 15.4 Merge Data Having Multiple Criteria or Multiple Columns in Power BI (Power Query) ( Download)
• How To Easily Merge Tables With Power Query: Vlookup Alternative ( Download)
• Advanced Concatenate/ Merge columns with Power Query ( Download)
• Power Query MERGE Challenge Solution - DUPLICATES Alert ( Download)
• Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel) ( Download)
• How to Join Two Tables on Multiple columns in Power BI | Join Two Tables on COMPOSITE KEY |BI Tricks ( Download)
• How to COMBINE DATA with MERGE and APPEND in Power BI ( Download)
• MERGING tables and how to use the different JOIN KINDS // Beginners Guide to Power BI in 2021 ( Download)
• Power Query - Dynamic Merge (Part 1) ( Download)
• Join Types in Power Query ( Download)
• 39. Join Tables / Merge Queries | Joins in Power Query Editor ( Download)
• 4 Ways of Getting Column from one table to another in Power BI ( Download)