➕ Append vs Merge 🔗 - Which one to use

How to choose the right one? Easy!

First, we have to understand what is the difference between the two of them.
One of them is going to COMBINE queries, while to other one works similarly to LOOKUP in Excel 🧠

You have probably guessed it right. Append is going to combine queries while Merge can help us to lookup values from other queries.

I hope that this video helps you to have a better understanding of these great Power Query features.

Have a good one,
Roland

💪 New videos coming every Tuesday 🤹‍♂‍

📝BLOG POST: https://bilingualanalytics.com.au/app...

🔗 REFERENCE MATERIAL
Join types: https://community.powerbi.com/t5/Data...
*Source: SqlJason

🎬 MORE VIDEOS:
How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips -    • How to prepare for the DA-100 / PL-30...  

Facebook Data Visualization in Power BI 👀 -    • Facebook Data Visualization in Power ...  

Power BI & Power Automate - How to automate reporting process -    • Power BI & Power Automate - How to au...  


▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲

🤝 HOW TO CONNECT 🤝
LinkedIn -   / bilingualanalytics  
Twitter -   / bilanalytics  
Subscribe -    / @bilingualanalytics  
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia

📽 GEAR:
📷 – Canon EOS 200D
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light
🎧 – BOSE QC35
🖥 – 2x ASUS VC279H
💻 – AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM


Music: www.bensound.com

#AppendvsMerge #PowerBI #BI-LingualAnalytics #BusinessIntelligence #DataScience #Data #DataAnalytics #Analytics #BI