Power Query -- add column to table will file modified data to Column for all rows

[Anonymous]

Good afternoon, I would like to be able to add the file modified data to a column for all rows of an appended query. I have built two queries that produce the output shown below in two tables/tabs. The 2nd query does basically the following: • Looks at files in published pricing folder for the current period Filters for *.xls files (to remove the PDF versions) • Filters for “Approved Pricing” file that are "published" there • Removes 6 top rows and promotes the 7th row as “header” (data/file cleaning) • Renames some of the columns names to be more identifiable • Appends all those files (several hundred files and thousands of rows into ONE table) The fist query/table just shows the file information, shown in (table 1). I need to modify the 2nd output/query to add a column that has the date modified from the originating file for each associated row in (table 2). I need this info for two reason: one for historical price changes, and 2nd because I will be working different project that will update the "billing: system" with the latest price. I am sure this step is likely quite simply, I just didn't know where or how to add that step in the 2nd query.

Thank you in advance., Kevin

(Table 2)

[ImkeF · Accepted solution]

Sounds like this could be the solution: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Combine-CSVs-and-Keep-the-File-Name/td-p...

[Anonymous]

Thank you that gave me  what I needed to work with!

Kevin

---

@ImkeF wrote:

Sounds like this could be the solution: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Combine-CSVs-and-Keep-the-File-Name/td-p...

---