https://d365hub.com/Posts/Details/8b494551-201e-402e-afe4-7be25b59c80f/new-semi-join-anti-join-and-query-folding-functionality-in-power-query