Forum Discussion
Something similar to excels CountIF in Query Editor
Hi Dandiel ,
yes sorry, my bad.
What you're trying to accomplish doesn't need any additional column. Just change the JoinKind in the merge-operation to: "Left Anti":
It automatically excludes all matches from the merged table.
See this blogpost for more details: https://www.poweredsolutions.co/2019/01/10/merge-operations-in-power-bi-power-query-part-3-left-anti-join/
Hi ImkeF ,
I assume you wanted to address me with your post.
I have edited my first post and provided sample data.
Thanks for trying to help me out.
Daniel
Community ChampionHi Dandiel ,
yes sorry, my bad.
What you're trying to accomplish doesn't need any additional column. Just change the JoinKind in the merge-operation to: "Left Anti":
It automatically excludes all matches from the merged table.
See this blogpost for more details: https://www.poweredsolutions.co/2019/01/10/merge-operations-in-power-bi-power-query-part-3-left-anti-join/