Forum Discussion
AllanBerces
Post Prodigy
Post ProdigySwitch
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
Thank you
- 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
6 Replies
- PhilipTreacy
Super User
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
AllanBercesHi 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.
- Houston-ho
Advocate I
Assumed the table named "Test", add a column with DAX,
Actual = SWITCH(Test[Comment], "Cancelled", "Non-Workable", "Tobe-Cancelled", "Non-Workable", Test[Comment])
- PhilipTreacy
Just add [Status] like this
Actual = SWITCH( TRUE(), [Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable", [Status] )regards
Phil