Forum Discussion
ViorelCa
Helper I
Helper IPower Query - Extract an Existing Column Name and put it in a new Custom Column
Dear Colleagues, I did not find a solution for a simple problem: Create a new custom column whose only content should be the name of an existing column in that Table. Many thanks! Viorel...
OK in that case your custom column's formula should be
= List.First(Table.ColumnNames(#"Insert Previous Step Here"))
...for whatever the previous step was. I'm going to guess it's #"Renamed Columns" or #"Changed Type" or something like that.
ViorelCaHelper I
Helper ISorry, let's say we have Column A, ColumnB and Column C.
I want to make a new conditional column (D) that is filled with this text: "Column A"
Many thanks!
Viorel
Go to Add Column, hit the Custom Column button and in the formula box type
= "Column A"