Setting Up Dynamic Source File Name

[negbc]

I'm looking to create a source file path to which the file name can change dynamically by date. I will have a daily extract to a folder, with the same naming convention "Name.YYMMDD" with that date being the extract date. In power query I want to connect, for example, to the file the is -7 days from today, or -14 days from today. Is there a way to format the file path so it changes everyday when the report freshes to file name that has the date corresponding to the date -7 days from the current day?

[dufoq3]

Hi @negbc,

= "Name." & Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()), -7), [Format="yyyyMMdd"])

[negbc]

Would this replace the entire source code? or would I still need some of the elements that as shown below and replace the file path with the code you provided?