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 )