In this project:
We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the Data Model in Power Pivot and create a DAX function and a Pivot Table.
Finally with a drop list we filter the data in the Data Model using a CUBEVALUE function.
We test by adding more files to the source folder and refresh the query and everything magically updates.
You can also learn how to Combine Data from Multiple Workbooks in Excel (using Power Query)
You can Download all Power query exercise files and Follow along by clicking on the button:
Watch the Video Tutorial Here:
Duncan Williamson
That was very good indeed. Thanks for sharing.