Column reference as variable

[Anonymous]

Hey guys,

I would like to replace a static value (in that case a column reference) by an variable:

I tried it the following way which didn't work:

"RemovedColumns[#"""& HierachyAttribute &"""]"

Would appreciate any hints 🙂

Thanks Dan

[Anonymous]

works like a charm! Thanks @Vijay_A_Verma 

[Vijay_A_Verma · Accepted solution]

You can try following (this will depend upon your context)

Table.Column(RemovedColumns,HierachyAttribute)

Example is below

    RemovedColumns = Table.RemoveColumns(#"Changed Type",{"Country"}),
    HierachyAttribute = "Sales Channel",
    #"Added Custom" = Table.AddColumn(RemovedColumns, "Custom", each Table.Column(RemovedColumns,HierachyAttribute))