Capture dynamic column name in variable in Power Query

[amsrivas]

Hi Folks!!

I have a excel source file with three columns as shown.

ColA

Name

Address

Col A name will change every day, say JAN, FEB etc, there is no exact fixed pattern of change in column name, it can be any Month name any time.

I want to capture this name of column in any variable say varA.

I have tried to use Parameter but parameter value is not chaning by its own even source got refreshed, i can understand, in Parameter we need to change value manually.

Is there any way out to capture the value of column in varA and that variable can be utilised further.

Thanks

Amit Srivastava

[mahoneypat · Accepted solution]

You can use Table.ColumnNames(#"Previous Step"){0} to get the name of the first column dynamically and use that wherever you would have used the text name of the column.  Replace #"Previous Step" with the appropriate step name.

Pat