Power Query and Data Validation are Much Stronger Together




 

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 and follow along by clicking on the button

A picture containing drawing Description automatically generated

Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link