➕ Append vs Merge 🔗 - Which one to use
ฝัง
- เผยแพร่เมื่อ 1 ต.ค. 2024
- 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: bilingualanaly...
🔗 REFERENCE MATERIAL
Join types: community.powe...
*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...
Facebook Data Visualization in Power BI 👀 - • Facebook Data Visualiz...
Power BI & Power Automate - How to automate reporting process - • Power BI & Power Autom...
▼▼▼▼▼▼▼▼▼
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: bilingualanaly...
📍 - 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
THANK YOU!
It’s my pleasure!
This really helped out with understanding this concept, thanks!