Assign a date to transaction level detail with Power Query

[Excel in Excel]

Hi there,

I have a daily report (.csv format) that can have anywhere from one or two, to several hundred transaction for the day. The report date is always displayed in cell C3 of the .csv file, but it is NOT displayed in a column next to each individual transaction. I would like to have this date information displayed next to each transaction so that when I combine all days into a single file, I can create a pivot table and summarize by date/week/month, etc.

 

[Excel in Excel]

I found a way to shortcut this for my scenario. The file name for all of my .csv files contains the date as the first 8 characters. In order to add the date as its own column, first I pull in all the files in the folder, then I add a custom column and use function =Csv.Docment([content]). Next, I expand this new custom column to display the contents of the files. Then I am able to create a custom column and use the function =Text.Start([File Name],8); this gives me a brand new column with a date next to every single transaction. I can then filter the data any way I want in the query to exclude certain rows, columns, etc. Seems to be working quite nicely.