PowerQuery Question: Query Folder - only keep most recent file

Question

I've got a folder where files accumulate that contain data about inventory position.  I am using other queries to extract trended data from the combination of all those files.  Now need a query that just grabs the most recent file so I can show current inventory information.

Each file contains the save date, for example:  Inventory Position - 2016 06-30.csv

Answer 1

Hi Porter,

Please follow these steps to get data from the most recent file in a folder:

1. In the data ribbon select New Query->From File->From Folder
2. Browse to the required folder and click OK.
3. Once the query preview pops up click Edit
4. Power Query displays a list of files in the folder. To get data from the latest one sort the list by Date Created or Date modified
5. Click Keep Rows-> Keep Top Rows-> In ‘Number of Rows’ type 1 to keep the latest file only and click OK
6. On the content column click Binary
7. Continue analyzing your data

Hope that helps.

Koby

-

Answer 2

Hi Porter,

Since the issues is related to Power Query, you may post your query in Excel IT Pro for better results.

You may refer to the below link to redirect to Excel IT Pro Forum.

http://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

If you have further questions related to this, please let us know.

Thank you.