Error Checking in Excel
Likes Likes:  0
Results 1 to 3 of 3

Thread: Power Query 2nd Oldest file in folder

  1. #1
    Board Regular
    Join Date
    Jan 2004
    Location
    Fife, Scotland
    Posts
    1,428
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query 2nd Oldest file in folder


    Power Query 2nd Oldest file in folder
    I am trying to do a comparison between the latest and previous file in a folder.

    I can pull the latest file in the folder easily, but is there any way to filter to the second oldest (by create date)

    Thanks for assistance

  2. #2
    Board Regular
    Join Date
    Jan 2004
    Location
    Fife, Scotland
    Posts
    1,428
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query 2nd Oldest file in folder

    Got it !

    If I use "is not latest" and then follow this with a "is latest" I get the second oldest file.

  3. #3
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,084
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query 2nd Oldest file in folder

    You may also find my video explaining how to compare a record with a previous record in Power Query useful.
    Matt Allington is a professional Power BI consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia at https://exceleratorbi.com.au.
    Author of the books Supercharge Power BI and Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •