Forum Discussion
Negative join
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
Anonymous Use EXCEPT in DAX. Use Left or Right Anti in Power Query Merge query.
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
4 Replies
Anonymous Use EXCEPT in DAX. Use Left or Right Anti in Power Query Merge query.
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
Anonymous , Try like a new table
new table = Except(Table1, Table2)
Both should have the same columns