Forum Discussion
Power Query -- add column to table will file modified data to Column for all rows
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)
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/151525
2 Replies
- ImkeFCommunity Champion
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/151525
- AnonymousNot applicable
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/151525