DAX,SQL的字符比较

SQL

下表字符查找比较：

DAX

Name LIKE 'SQLBI'

Table[Name] = "SQLBI"

Name LIKE 'SQLBI%'

LEFT( Table[Name], 5 ) ="SQLBI"

Name LIKE '%SQLBI'

RIGHT( Table[Name], 5 ) ="SQLBI"

Name LIKE '%SQLBI%'

SEARCH("SQLBI", Table[Name], 1, 0 ) > 0

for PowerPivot v1:

IFERROR(SEARCH("SQLBI", Table[Name], 1 ), 0 ) > 0

Name LIKE 'SQLBI%Methodology'

LEFT( Table[Name], 5 ) ="SQLBI" && RIGHT( Table[Name], 11 ) ="Methodology"

Name LIKE 'SQLBI%Methodology%'

LEFT( Table[Name], 5 ) ="SQLBI" && SEARCH("Methodology", Table[Name], 1, 0 ) > 0

Name LIKE '%SQLBI%Methodology%'

SEARCH("SQLBI", Table[Name], 1, 0 ) > 0 && SEARCH("Methodology", Table[Name], 1, 0 ) >SEARCH("SQLBI", Table[Name], 1, 0 )