Performing a full Anti Join in Power Query - Compare Two Tables

This video breaks down how you perform a full anti join in Power Query. You can find a left anti-join and a right-anti join in the user interface. The full anti-join requires a custom approach. Let's get started!

WRITTEN BLOGPOST:
https://gorilla.bi/power-query/join-types/

Master Functions and Syntax in M
https://powerquery.how

Chapters
00:00 Introduction
00:27 Dataset
01:02 Anti-join method 1
04:04 Anti-join method 2

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.

Website: https://gorilla.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_confirmation=1

LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: https://facebook.com/BIGorilla/
Twitter: https://twitter.com/rickmaurinus
LinkedIn: https://linkedin.com/in/rickmaurinus/

Thank you for your support!

#FullAntiJoin#PowerQuery #BIGorilla

Видео Performing a full Anti Join in Power Query - Compare Two Tables канала BI Gorilla