Calculated Column that can dynamically change?

[binhp]

Hello

I have a calculated column with a switch statement. I want to return another column based on a value of another column.

My switch statement:

ColumnSelection = SWITCH(TRUE(),
                VALUES(ColumnTable[ColumnList])="Program", 'Table'[Program],
                VALUES(ColumnTable[ColumnList])="Campaign", 'Table'[Campaign],
                BLANK())

But the error says it expects one value. 

How can I get this to work?

I'm basically trying to implement this, but with a calculated column.
http://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-vi...

[Greg_Deckler]

In general, calculated columns are not dynamic, they are calculated at the time of data load and not again until the next data load. Need to use measures to get dynamic behavior.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490