Is it possible to populate a column with the name of another table?

[Anonymous]

Hello

If I load a table from an excel file to PowerBI, can I create a new column in the table and populate it with values that equal to the name of the loaded table?

In other words, can I use the name of a table as a variable or value to put in fields?

Thanks!

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft]

Hi, @Anonymous 

Based on your description, you may click 'Edit Query', go to Query Editor, create a new blank query.

If you use Excel connector, you may input the following codes in the 'Advanced Editor'.

Then you need to input the Filename to get the result.

If you use folder connector, you may input the following codes in 'Advanced Editor'.

Here is the result.

Best Regards

Allan

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

[camargos88]

Hi @Anonymous ,

If you are using Power Query you can go to to 2nd step and filter the files you wanna get, remove the other columns and expand the rows...so you will get a column with the sheet name.

Ricardo

[Anonymous]

Thanks but not sure if I was understood.

The xls I am loading is called Excel1.xls and its sheet is called Table1.

The table it contains is:

Header1	Header2	Header3
r	k	f
o	b	r
e	v	p

I want to create a table like this:

Header1	Header2	Header3	NewColumn1	NewColumn2
r	k	f	Table1	Excel1
o	b	r	Table1	Excel1
e	v	p	Table1	Excel1

How can I do that?

Thanks!

[camargos88]

@Anonymous ,

Check this file: Download PBIX 

Just go to Transform Data and edit the parameter for path.

Ricardo

[amitchandak]

@Anonymous , Example of moving data from one table to another

New column in table1

New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])