Forum Discussion

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
4 years ago

Dynamically Set Data Source Links

The situation I have is that one department creates spreadsheets ~1x per month and puts them in a shared folder. Then the next year starts a new folder. I have a report that wants to use the most rec...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Cmcmahan maybe the easier would be, after you list all the files, first add a step to sort by report date (z to a), in the next step, keep the first row, so you will be left with the most recent file, and then just expand it, no more, parameters etc will be required.

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

  • kiyoshi-co-uk's avatar
    kiyoshi-co-uk
    New Member
    1 year ago

    Did this work for anyone? I tried using Get.Files to grab a list of tiles, then TAKE() the one with latest date, and use that... but hit a brick wall.

     

    I'm doing this 100% in Excel, not Power BI; gotta grab a range of data from a file that changes its filename based on the date, and so have tried to dynamically generate this via INDIRECT() to no avail. Ack!