In this tutorial I am bringing multiple files from a Folder, I combine the Files together, clean and transform the data and create calculations in Power Query to return a nice report to Excel.
I then create 2 Drop Lists in Excel: one to select a different Source folder and the other to select a different customer. I link the 2 drop lists to the first query and create a simple dynamic dashboard.
You can Download the Exercise File of power query and data validation and follow along by clicking on the button
