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: [ Ссылка ]

🔗 REFERENCE MATERIAL
Join types: [ Ссылка ]
*Source: SqlJason

🎬 MORE VIDEOS:
How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips - [ Ссылка ]

Facebook Data Visualization in Power BI 👀 - [ Ссылка ]

Power BI & Power Automate - How to automate reporting process - [ Ссылка ]


▼▼▼▼▼▼▼▼▼
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 - [ Ссылка ]
Twitter - [ Ссылка ]
Subscribe - [ Ссылка ]
ABOUT ME: [ Ссылка ]
📍 – 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

свернуть