Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 146

Figure 7-23: Select one of the Excel files in the target directory and navigate to the sheet holding the
data that needs to be consolidated.
Figure 7-24: Open the Advanced Editor to see the starter code.
6. Wrap the entire block of code with your function tags, specifying that this function requires
two parameters: FilePath and FileName.
The hard-coded file path and filename have been replaced with their respective parameters,
as shown in Figure 7-25.
7. Close the Advanced Editor.
8. In the Query Settings pane, change the name of the query in the Name box. Give your func-
tion a descriptive name (in this scenario, fGetMyFiles).