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
Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

lbendlin  the import has a date column already--I just do not want to pull in this many files and those in charge of the file structure will not archive old files in a different folder. I want to pull files by > than date then also create a Dax Formula that makes the data red when the files have not pulled in by a certain date.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago
    the import has a date column already

    Which one would that be?