Forum Discussion

binhp's avatar
binhp
Frequent Visitor
8 years ago

Calculated Column that can dynamically change?

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-via-a-slicer/ba-p/87027