Conditional JOIN using Power Query | A different way of merging in Power BI

How to Power BI
How to Power BI
57.3 هزار بار بازدید - 3 سال پیش - In this video I show
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 https://datatraining.io/powerbi-how-to

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

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbi-busin...

For Custom Trainings and Consulting email directly [email protected]

---------------------------------
⏱️ 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              https://bit.ly/4b453bi
Subscribe    https://bit.ly/31MnQGO​
Insta             Instagram: howtopowerbi
LinkedIn       LinkedIn: basdohmen
TikTok          TikTok: how.to.power.bi
X                    Twitter: HowToPowerBI
fb                   Facebook: howtopowerbi
Threads        https://www.threads.net/@howtopowerbi
Newsletter   https://datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear  https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referra...
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://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
3 سال پیش در تاریخ 1400/03/06 منتشر شده است.
57,338 بـار بازدید شده
... بیشتر