Make an Excel file crash at a specific date

Hi, Anonymous 

If you want to use the latest file, you may try to create a function in Power Query, which always loads the newest created file using folder connector.

First you need to create a blank query and paste the codes in 'Advanced Editor'.

let
    Source = (Path as any) => let
        Source = Folder.Files(Path),
        Custom1 = Table.SelectRows(Source,each [Date created]= 
    Table.Max(Source,"Date created")[Date created]
    )
    in
        Custom1
in
    Source

Finally you may input the folder path to get the newest created file in the folder.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.