Confused with all the join/ merge types options available in Power BI Desktop? No worries, we explain all types in detail here.
If I say: Left Anti, or Full Outer, do you know inmmediately what it is or do you think I am calling you bad names? Smiley Happy
Every time I created a merge in Power BI Desktop or Excel, I had to pause and take deep breaths as I scrolled down the list of join types available. Some are very obvious, but Left Anti? Really?
Let's put an end to our merge anxiety, here is your ultimate guide on Join/ merge types in excel and Power BI.
Download the excel demo file: https://gofile.me/2kEOD/bjdeT9MNZ
Jump directly to the type of join you want to understand with our keynotes.
Left Outer Join 01:37
Right Outer Join 02:51
Full Outer Join 03:20
Inner Join 03:39
Left Anti Join 03:52
Right Anti Join 04:17
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
Contact us: http://www.curbal.com/contact
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
Many thanks in advance!
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
► Linkedin: https://goo.gl/3VW6Ky