How to add Excel parameters to Power Query.
UPDATE: PQ now has parameters but they are not what this covers.
https://www.dropbox.com/s/bj7azeagd97wtil/PQ%20Parameterized%20Simple.xlsx?dl=1
Sample workbook can be downloaded from Beyond Excel (click link above)