Using Dynamic Column Name in Function

[SWT01]

Hi All,

I need to Get the Sum of a specific Column from a table Called Outputs. I use the below Logic. However it is not working. It is considering ColName as a name of the column whereas it should consider Total as the column name. Is there any way to solve this

let
ColName="Total",
FilteredTable = #"Output",
result = List.Sum(FilteredTable[ColName])
in
result

[AlienSx · Accepted solution]

Table.Column