WHERE clause based on related tables



I have two tables. Invoice Header, and Invoice Lines. In normal SQL you can do something like

SELECT InvoiceNo, Quantity FROM InvoiceLine WHERE InvoiceHeader CustomerNo = ‘564645’

Is it possible to do that in Power Query, if so what’s the syntax?


Yes, it is possible to something like that. Need a more specific question and data in order to give a proper response.