Negative join

[Anonymous]

Hi

Is there a way to preform a "negative join" where i will keep all posts from the first table that are not in the second table?

Regards

Søren

[Greg_Deckler · Accepted solution]

@Anonymous Use EXCEPT in DAX. Use Left or Right Anti in Power Query Merge query.

[amitchandak]

@Anonymous , Try like a new table

 new table = Except(Table1, Table2)

Both should have the same columns

[Greg_Deckler · Accepted solution]

@Anonymous Use EXCEPT in DAX. Use Left or Right Anti in Power Query Merge query.

[Anonymous]

Thanks for the answer

That is SQL? 

I am working with a M query.

Regards

Søren

[amitchandak · Accepted solution]

@Anonymous , there is an option in merge , anti join ?

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Function of power query

https://docs.microsoft.com/en-us/powerquery-m/joinkind-leftanti