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:
gorilla.bi/power-query/join-types/
Master Functions and Syntax in M
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: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
youtube.com/bigorilla?sub_confirmation=1
LET'S CONNECT:
Blog: gorilla.bi
Facebook: facebook.com/BIGorilla/
Twitter: twitter.com/rickmaurinus
LinkedIn: linkedin.com/in/rickmaurinus/
Thank you for your support!
#FullAntiJoin#PowerQuery #BIGorilla
- Performing a full Anti Join in Power Query - Compare Two Tables ( Download)
- Easily Compare Two Tables in Power Query ( Download)
- Use Anti-Join in Excel with Power Query | Everyday Office ( Download)
- Right anti join in Excel 32 ( Download)
- How can I use the Left Anti join function in PowerQuery ( Download)
- Easily Compare Multiple Tables in Power Query ( Download)
- How To Filter Data Using Anti Join In Excel With Power Query ( Download)
- The Left and Right Anti Joins of Power Query 🔥 ( Download)
- Join Types in Power Query ( Download)
- Compare Tables for Unmatched Records in Excel with Power Query ( Download)
- Compare Two Columns with Microsoft Excel Power Query | Excel Formula Hacks ( Download)
- Left Anti Join & Right Anti Join in POWER QUERY / POWER BI ( Download)
- Power Query (Excel) + M Code | Compare multiple tables - No Code to M Code (MATCH) ( Download)
- Conditional JOIN using Power Query | A different way of merging in Power BI ( Download)
- Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins Explained ( Download)
