Default Column on Power Bi

Hi All,

I imported multiple csv files to one of my  Power Bi report.

Each time I need to add one column manullay and put values for each table/file. Valuse is same in each file.

Can we add column name (auto) on the power bi with the values?  Each file has same Name values for each row.  

So after import I do not need to add column & values manually.  

An example

FILE1

Col 1 - Col 2, Col 3 etc from file.

I added column called Name and put values file name for each row.

FILE2

Col 1 - Col 2, Col 3 etc from file.

I added column called Name and put values file name for each row.

Thanks