Queryname or table name als column in Query

[JSK1999]

Bye all,

I would like to add the query name as a column name in my Power Query.

For example, the query name is "Cost1", so I would then like to have a column cell with the data "Cost1" at each row.
Or is there any way to add the table name as the column name

Is there any particular formula I can use to get this result?

Thanks in advance.

 

[alansidman]

Add A Column Tab. Name the column header. in the window, type ="Cost1"

 

[JSK1999]

Add A Column Tab. Name the column header. in the window, type ="Cost1"

Thank you, but isn't there any way to automate this?
If I change the name to Cost2, that it automatically updates the column.

Thanks in advance.

 

[alansidman]

See if this response works for you

Custom Column with Origin of Table

I have a power query with 14 tables from 14 sheets. The columns on each table vary. Some have columns unique to a sheet. They all share about 10 columns, but the order varies. How can I go about a...

superuser.com