Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |