SQL,DAX的比较

以下SQL和DAX一样：

1，

SQL

SELECT *FROM Product

DAX

EVALUATE Product

2，

SQL

SELECT [Product Id], [Product Name], [List Price]FROM Product

DAX

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

DAX

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

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

SQL

SELECT DISTINCT [Product Id], [Product Name], [List Price]FROM Product