Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
stav
New Member

Removing Matching Rows

Hello,

 

I'm having a hard time figuring out how to remove matching rows between two tables. I've tired the merge function but it only keeps rows that match between the two tables. Is there a way to merge two tables but only keep values that don't match in both? I have one query that only shows dates for from the last month and another query that shows the previous 2 months. After merging I only want to show what the dates that didn't match.

 

Example:

                     

Table A:                     Table B:               After Merging--->          Table C:

CreateDate                 CreateDate                                             CreateDate

6/1/17                       7/1/17                                                    6/1/17

6/15/17                     7/15/17                                                   6/15/17

7/1/17                       8/1/17

7/15/17                     8/15/17

8/1/17

8/15/17

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

You need to change your Join Kind at the bottom of the Merge interface to be a Left or Right Anti.

 

Check out the documentation on Table.NestedJoin

 

https://msdn.microsoft.com/en-us/library/mt260794.aspx

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

You need to change your Join Kind at the bottom of the Merge interface to be a Left or Right Anti.

 

Check out the documentation on Table.NestedJoin

 

https://msdn.microsoft.com/en-us/library/mt260794.aspx

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thank you so much! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.