Forum Discussion
Related column and conditional column
hi all... I have a column value using related. for example, how do i create a column, if country has Asia, then "Asia" else "others" I am not able to use conditional column? Any advice is grate...
Anonymous
try
SWITCH( TRUE(), CONTAINSSTRING(Table[Country],"AsiaPac")=TRUE(), "AsiaPac", CONTAINSSTRING(Table[Country],"Asia")=TRUE(), "Asia", "Others" )do not hesitate to give a kudo to useful posts and mark solutions as solution
sanalyticsThanks,it work, i tried using 3 conditional but not sure how to do it.
any idea
condition1 - if table contain Asia - then asia
condition1 - if table contain AsiaPac - then asiaPc
else Others
Anonymous
try
SWITCH(
TRUE(),
CONTAINSSTRING(Table[Country],"AsiaPac")=TRUE(), "AsiaPac",
CONTAINSSTRING(Table[Country],"Asia")=TRUE(), "Asia",
"Others"
)do not hesitate to give a kudo to useful posts and mark solutions as solution