DAX

来源：互联网发布：linux apache2 php7 编辑：程序博客网时间：2024/05/16 08:37

下表字符查找比较：

SQLDAX

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 )

以下SQL和DAX一样：

1，

SQL

[sql] view plaincopy
SELECT *FROM Product  

DAX

[plain] view plaincopy
EVALUATE Product  

2，

SQL

[sql] view plaincopy
SELECT [Product Id], [Product Name], [List Price]FROM Product  

DAX

[sql] view plaincopy
EVALUATEADDCOLUMNS(    DISTINCT( Product[Product Id] ),    "Product Name", CALCULATE( VALUES( Product[Product Name] ) ),    "List Price", CALCULATE( VALUES( Product[List Price] ) ))  

DAX

[sql] view plaincopy
34567   
  
EVALUATESUMMARIZE(    Product,    Product[Product Id],    Product[Product Name],    Product[List Price])   

也许更准确地，上面SUMMARIZE相当于SQL的SELECT DISTINCT 语句，既：

SQL

[sql] view plaincopy
SELECT DISTINCT [Product Id], [Product Name], [List Price]FROM Product  

Converting MDX to DAX – First Steps

http://www.sqlbi.com/articles/converting-mdx-to-dax-first-steps

0 0