How to APPEND or MERGE data / DAX or Power Query // Demo + Best Practices when using with Power BI

Подписаться 44 тыс.

Просмотров 13 тыс.

50% 1

Get Demo Files here
ko-fi.com/s/cd66bdc9fa
In this video were going to go through the difference between Append and Merge, demonstrate how to do both using either DAX or Power Query AND talk about when and why you should use them.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@tonianibal7585 Год назад

Thanks a lot, I didn't know how to make a SQL Select/Union in DAX and you demonstrate it with excellence.

@alexking8222 2 года назад

This was perfect, exactly what I was looking for :-)

@SolutionsAbroad 2 года назад

Great, glad it helped!

@RicardoSadaJapp Год назад

Thanks! Very good tip and very well explained.

@philipedesouzasantos1201 9 месяцев назад

Really helpful, thanks a lot.

@tei9523 Год назад

VERY HELPFUL!

@samoptimizer 9 месяцев назад

Awesome thank you so much 🍀🍀🍀

@marcelocabral5096 2 года назад

great video, tks so much :)

@heidicroft1088 Год назад

As a best practice, if you append in Power Query, should you turn off enable load on the original queries so that only the full table gets loaded? If you don't do this, when you load the tables, will it effectively update the data twice for each table?

@SolutionsAbroad Год назад

Hi there great question! So queries no set to load will still be used by Power Query to process your steps, it just won’t be loaded to your final results, which does reduce the load time (since power bi has less tables to load) as best practice you should only load data that you’ll use for any calculations or visualisations

@seyiabayomi 2 года назад

Every insightful.

@SolutionsAbroad 2 года назад

Thanks for your support David!!

@SolutionsAbroad 2 года назад

Thanks for your support David!!

@SolutionsAbroad 2 года назад

Thanks for your support David!!

@vineetbhushan4688 5 месяцев назад

Can we append a table and power bi dataset other report

@lagudaadeyemi8359 2 года назад

whats the difference between merge, append, and union? thanks

@davidlopez-fe2lb Год назад

Append & Merge is Power BI's version of Joins & Unions. Append = Union & Merge = Join.

@JJ_TheGreat 2 года назад

If you need to both Append and Merge, is it better/more efficient/effective (from a memory standpoint, etc.) to Merge and then Append, or Append and then Merge? Thanks.

@SolutionsAbroad 2 года назад

Hey JJ, super amazing question! From your logic it sounds like a Merging and Appending would result in incorrect and fewer data (Appending after will not match any values in your second table). A more efficient way to handle this correctly is to append your data then create a relationship between your two tables

@davidlopez-fe2lb Год назад

Append then Merge, if not you'll be doing a very similar merge multiple times....i.e. merge on country from region table to sales table for month 1 and then do it again for month 2 and then do it again for month 3, so 1 append and 3 merges. As opposed to Appending Month 1/2/3 and then doing the merge, so it'd be 1 append and 1 merge, also as mentioned a dynamic relationship is even better.