How to get filename as column value while combining files in folder data source

[rahuldas_vgm]

Hello,

I have a folder connection as datasource where all csv files are combined and transformed. I am splitting the file name to get the file date (dd/mm/yy_Filename.csv) before expanding the content column as the final step to combine all the files in the folder. I need to get a column with the respective file dates inside the expanded combined dataset to identify which data belongs to its respective dated file.

Any help with this issue would be of great help!

Thank You!!!!

[Mahesh0016 · Accepted solution]

>>I hope this post helps you.
https://community.powerbi.com/t5/Desktop/adding-the-file-name-to-a-column-in-power-query/td-p/212533...

[rahuldas_vgm]

Thank You @Mahesh0016 it resolved the issue I was facing. Thank You again.