WHERE clause based on related tables


#1

Hi,

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?


#2

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

Thanks
Jarrett

Enterprise%20DNA%20Expert%20-%20Small