link query to latest file in folder

[rjmdc]

how do i direct the query to take source as latest file in the folder
files are updated once a month and worked on every day

 

[sandy666]

you can try with

Table.SelectRows(Source, let latest = List.Max(Source[Date modified]) in each [Date modified] = latest)

or use any other column with dates that you think will be better for your needs

 

[rjmdc]

how do i link ths to the source folder?

 

[sandy666]

how do i link ths to the source folder?

use From Folder feature

 

[rjmdc]

basically these are the steps i took
is this correct?
get data
from folder
transfor
sorted by modified date descending
kept top row
expanded the binary
chose the table to modify

if this is the query then it will always tske the latest file?

 

[sandy666]

no, use From Folder feature then Edit and then on column [Date modified] use filter isLatest
after that you can do what you want

you asked about how to select latest file in folder not what to do with the data

 

[rjmdc]

thanks that works perfectly
just 2 steps and i have the latest file
wow!

 

[sandy666]

You are welcome and thanks for the feedback
Have a nice day