From here you make the selection of the files you need. This is a main step in preparing the consolidation. It displays information on the available files in the source folder. In the next section you will learn what filters to put in.Īfter clicking Edit you land at the screen below. I recommend to always choose Edit to filter out unnecessary files. In this screen you get the opportunity to change what files you want to consolidate. Edit: after clicking Edit, a new screen appears.Load: this option will load the table as displayed above into Excel (without the actual sales data).I do not recommend this option because it does not allow for error-proofing your consolidation solution. Instead Combine takes every file in the folder. It skips the Edit step, and gives you no control over what files to combine. Combine: this option leads to a screen where you can choose what data to combine.The three options to consider in above screen are combine, load and edit. Next to those files, the folder contains two files that we don’t want to consolidate. For consolidation we need the sales data for the months April to June, as marked yellow. Select the folder containing the files to consolidate -> Click OK.īelow picture shows all the files available in the source folder. Go to the tab Data -> click Get Data -> From File -> From Folder.All files contain a table named “ ProductSales”. The files for May and June are identical, except for the date column. Below image shows the file containing Sales data for the month April. I have made three example files containing sales data for the months April, May and June. Import from Folder: Consolidation Magic!.Instruct Power Query how to Combine Files.
0 kommentar(er)
