HELP! How to have a column showing the file name

[Anonymous]

i'm importing multiples excels from and appending them via the import from SharePoint Folder options. 

each month has 1 excel file, showing the sales by product for each month, all in the same folder:

eg as below, (in each excel file, there's no column to indicate sales month, it's only based on the file name)

file name | product | sales

1.xlsx       | A            | 10

2.xlsx       | A            | 20

when i comebine the files together, using the "combine file" button at the content column

i managed to have all data from different excel files combined together, but there's no indicaation of which month each row comes from and hence i can't tell the sales come from which month. 

how can i add a column to indicate the file name of the souce excel file?

thanks. 

[v-jayw-msft]

Hi @Anonymous ,

Refer the below topic as well.

https://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-Power/m-p/22851

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Refer the solution

https://community.powerbi.com/t5/Desktop/Keeping-File-Name-as-a-Column/m-p/792666