Forum Discussion
Solved
Filter only the most recent data in Power Query
Hi! I have a folder where users upload Excel files with weekly data. All the files they upload have the same name and structure; the only thing that changes are the rows, as each file refers to a si...
- Connect to the folder with your files.
- Filter to only .xlsx files.
- Sort the files by Date created descending.
- Keep the top (most recent) file.
- Use its full file path to load the Excel data dynamically.
- Connect to the folder with your files.
- Filter to only .xlsx files.
- Sort the files by Date created descending.
- Keep the top (most recent) file.
- Use its full file path to load the Excel data dynamically.