Filter Excel data before load into PowerQuery

[JEB85]

Hi,

I have a folder with numerous excel files (5 years * 12 monthly files). Within powerquery i only ever want to import the last 12 months worth of data.

Obviously i can use the date filters when the data has been imported but is it possible to filter before i expand the table contents? My query would be much quicker if i could do this.

Of course, i could just only ever have 12 months of files in the folder and update monthly but if there's a way i can get around this with powerquery then i will take that option.

Thanks

 

[Comfy]

Does the file name contain a period or data?

Extract the date/period from file name and then filter.

 

[JEB85]

It does - great idea Comfy! Thanks