Forum Discussion
Solved
Switch
Hi good day can anyone help me on my new column base from my table below, basically if the comments is Cancelled and Tobe- Cancelled the actual colunm should reflect Non-Workable. OUTPUT ...
- Actual = SWITCH(Test[Comment], "Cancelled", "Non-Workable", "Tobe-Cancelled", "Non-Workable", Test[Status])
Just add [Status] like this
Actual = SWITCH( TRUE(), [Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable", [Status] )regards
Phil
What about the other values in the column like Not Started, Completed, In Progress?
You can use IF or SWITCH
Column = IF([Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable")
Column =
SWITCH(
TRUE(),
[Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable"
)
Regards
Phil
Hi PhilipTreacy thank you for the quick reply and for the Actual will copy the word is status column as long its not Cancelled and Tobe- Cancelled in comment column.
Assumed the table named "Test", add a column with DAX,
Actual = SWITCH(Test[Comment], "Cancelled", "Non-Workable", "Tobe-Cancelled", "Non-Workable", Test[Comment])- Actual = SWITCH(Test[Comment], "Cancelled", "Non-Workable", "Tobe-Cancelled", "Non-Workable", Test[Status])
Hi PhilipTreacy Houston-ho thank you very much, working great.