有一个我必须匹配的要求一个具有多个值的表达式(来自下面的语法)
have a requirement where I have to match one expression with multiple values (from syntax below)
SWITCH(< expression>,< value>,< result> [,< value>,< result>] ... [,< else>])
I我正在写一个完全正在寻找的伪代码,问题是,我如何匹配一个< expression> < value>的多个值在上面的语法
IF列IN('a','b','c','d','e','f') - 1 THEN
IF column IN ('a','b','c','d','e','f') -- 1 THEN
IF( column2喜欢'%tst%'或列IN('a','b')) - 2那么 IF栏IN( 'd','e')然后 [使用此栏目]; ELSIF栏IN('b','d',' e','f')THEN [使用此栏目]; END IF;
IF (column2 like '%tst%' OR column IN ('a','b') ) -- 2 THEN IF column IN ('d','e') THEN [use this column]; ELSIF column IN ('b','d','e','f') THEN [use this column]; END IF;
ELSE - 2
ELSE -- 2
0 END IF; - 2
0 END IF; -- 2
END IF; - 1
END IF; -- 1
推荐答案
DAX同时具有IF函数和IN运算符,因此您的伪代码将转换为如下所示:
DAX has both an IF function and the IN operator, so your psuedo code would translate to something like the following:
IF (column IN {"a","b","c","d","e","f"} -- 1 ,IF (SEARCH( column2 , "tst",1,0) > 0 || column IN {"a","b"} ) -- 2 ,IF( column IN {"d","e"} ,[column] , IF( column IN {"b","d","e","f"} ,[column]) ) ,0 ) -- 2 ) -- 1
更多推荐
切换dax
发布评论