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

Really helpful, thanks a lot.

Awesome thank you so much 🍀🍀🍀

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

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?

Thanks! Very good tip and very well explained.

VERY HELPFUL!

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

great video, tks so much :)

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.

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

Every insightful.