Get data from the latest file in a folder with Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Check out the blog post for more details ★
https://exceloffthegrid.com/data-late...

★ About this video ★
Our ability to manage inputs effectively is critical to building automated processes in Excel. A common reporting scenario is to get data from the latest file. This generally occurs where each file includes the historical data; therefore, we only need the latest file.

In thisvideo, we are exploring how to create an efficient solution for this situation.

0:00 Introduction
0:16 Connect to folder
0:55 Available fields to identify the latest file
2:17 Steps to get to the latest file
3:34 Testing the solution
4:08 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel