CSV import - How to preserve "Date created" column in the report

[lusine]

Hi,

I am creating report that is based on cumulative data from multiple CSV files. Since each of those CSV files are snapshots and they don't have date column it's very important for me to preserve "Date created" (date when file was created), of each file in my cumultive report.

Initially, when I upload all CSV files I get following columns: Content (Binary), Name(file name), Date created (date when file was created), Attributes, etc...

How do I preserve "Date created" (date when file was created) column? Whenever I expend Binary, "Date created" is lost.

Would appriciate your help.

Thank you

[Rfranca]

Csv.Document

[v-yuta-msft · Accepted solution]

Hi lusine,

Based on your description, you are using get data from folder, and you want to add a created date column to each table, right?

First click Binary, then add a step using M code like below:

#"Add Column" = Table.AddColumn( #"Changed Type", "Created Date", each Source{[#"Folder Path"="C:\Users\v-yuta\Desktop\Test\",Name="Test.csv"]}[Date created])

Regards,

Jimmy Tao

[langkio]

Hello Jimmy, 

I also have the data source linked to a folder, but the code did not work for me. I have two files currently in the folder with different created dates. Is it possible to have an additional date created column in each of the table? I was thinking of appending the two tables once I have the date to distinguish the two tables. Thanks.