Add invoice number as a parameter to power query

[gazmoz17]

Hi,

How do I do this so I can pull through only invoices which are greater than my invoice number in cell A2. This cell itself is looking up another collum on another sheet.

Thanks

 

[alansidman]

I have prepared a sample parameter query in Box. Net. Here is the link to that file so you can see the steps taken in detail.

PQ-Parameter Query.xlsx | Powered by Box

app.box.com

In the example, change the invoice value on the first sheet, source data is in the third sheet and after selecting the invoice, click on refresh all and the results will be on the second sheet.

 

[gazmoz17]

Hi,

Thanks for that Alan I think I was able to see how that worked .

Sheet 2 is just a static table.
Table 1 Queries from Sheet 2.
Sheet 1....you make your parameter as a table. Close and load connection only.

I think I get it but can you clarify this step please?...do I number filter the content in parmater box and then replace that with parameter name?

Many Thanks really helpful

 

[alansidman]

do I number filter the content in parmater box and then replace that with parameter name?

Yes. That is exactly how you do it. In the parameter, once you have loaded it, you will need to right click and drill down.

 

[gazmoz17]

Thats great. Thanks Alan