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 )