Forum Discussion
Excluding Data from a CRM Query with M
Hello, I am pulling a large amount of data from a client MSX CRM and need to exclude data based on a table I already have available. Trouble is, I haven't touched M before and only have a passing...
You need to perform a merge in mode "Left Anti". See here for example: https://www.poweredsolutions.co/2019/01/10/merge-operations-in-power-bi-power-query-part-3-left-anti-join/
ImkeF
Community Champion
Community ChampionYou need to perform a merge in mode "Left Anti". See here for example: https://www.poweredsolutions.co/2019/01/10/merge-operations-in-power-bi-power-query-part-3-left-anti-join/
That worked! Thank you!