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/
Community ChampionHi Anonymous ,
you would help us answerers if you could post some sample data with before data and desired result.
Possible reasons for empty results are deviations in cases (as Power Query is case sensitive) or unprintable characters (use Text.Trim and Text.Clean before).
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
- ImkeF
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/