Forum Discussion
Over 45+ folder structures to pull .txt/.csv file from via Power Query
INTRO: My mission is to pull the most recent file from various folders that are sent from the PAYOR and organize them by the most recent date per payor. Then I must pull the values for TOTALS PAID b...
Thank you for your reply! The issue is how to just import .txt files > than a certain date. The dates are found in the name itself and the column pulled in Power Query. How can just have a refresh on file names > than , say , November 23rd, 2023? Thank you!
create a new date column from the file name, then apply your filter on that new column.
I must test that as I found if I do any filtering on the date column then when a new file enters the folders it does not update my slicer to show the latest file as it is obeying the filter placed.