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
Anonymous Use EXCEPT in DAX. Use Left or Right Anti in Power Query Merge query.
Thanks for the answer
That is SQL?
I am working with a M query.
Regards
Søren
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