Get only specific data from each file

[IPGeorgiev]

Hi All,

I am facing the following issues I cant solve.

I have a folder with multiple excel files which have the same data but for different data ranges. So as a data source I have the folder.

Each file has data for the previous 5 to 14 days. What I want is to have Power Query take only the data for yesterday (List.Max[Date])

Heres what I have, but it doesnt do the job:

Any suggestions?

Many thanks in advance!

Best regards,

ivan 

[FrankAT]

Hi @IPGeorgiev 

create a query that holds the date of yesterday (see figure). Check your import data and filter it against this query.

Don't bother about the date format it's localized.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[IPGeorgiev]

Hi @FrankAT ,

many thanks for the response!

Not sure if I got it wrong or didnt summarize my request correctly.

If I go with this solution this will work for the file I have uploaded today, however if it tries to filter a file from the 2nd of October (there we will have data only until the 1st of October) this wont work , I assume?

Many thanks!

Best regards,
Ivan 

[IPGeorgiev · Accepted solution]

Quick update:

I have managed to resolve this by following this:

https://www.poweredsolutions.co/2019/02/26/parameters-and-functions-in-power-bi-power-query-combine-...

and using the transformations from the first post.