Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

create a new date column from the file name, then apply your filter on that new column.

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

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.