Mastering DAX Workshop
You can use DAX to create calculated columns and measures, but you can also use DAX as a query language with the help of specific tools such as DAX Studio. The query syntax is based on the EVALUATE statement, which materializes to the client the result of a table expression. For this reason, after learning how to write DAX queries using EVALUATE in DAX Studio, you will learn a number of table functions useful in both queries and other DAX expressions.
You will see functions to filter rows, such as FILTER, CALCULATETABLE, and TOPN; functions to group rows and project columns, such as SUMMARIZE, SUMMARIZECOLUMNS, GROUPBY, and SELECTCOLUMNS; functions to manipulate tables, such as CROSSJOIN, GENERATE, and conditions might affect the data lineage in different ways.
You will also see other utility functions, such as ROW, LOOKUPVALUE, and CONTAINS, TOPN, UNION, INTERSECT, and EXCEPT, SUMMARIZECOLUMN and GROUPBY.
Finally, you will learn how to create measures local to a query, how to inject parameters in a query, and how to use DAX measures in MDX queries. These techniques are very useful to improve productivity when you are developing and testing new measures.
After a quick recap, you can start Lab 6.
Log in or purchase access below to the premium version of this content.
Time Intelligence in DAX
Mastering DAX Workshop (Current)
1.
Introduction to DAX 1-hour 1-minFree
2.
Table Functions 32-min
3.
Evaluation Contexts 42-min
4.
CALCULATE Function 32-min
5.
Evaluation Contexts and Relationships 1-hour 8-min
6.
Building a Date Table 19-min
7.
Working with Iterators 36-min
8.
Time Intelligence in DAX 56-min
9.
Querying with DAX 1-hour 9-min
10.
Hierarchies in DAX 28-min
11.
Advanced Relationships 1-hour 14-min
12.
Lab Exercise Files and Presentation PDF
Purchase A Full Access Subscription
- Payment is instant and you will receive a tax invoice straight away.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
Jump to a chapter
- Introduction to Querying with DAX (00:09)
- DAX Studio (01:19)
- EVALUATE Syntax (02:30)
- FILTER and CALCULATABLE Functions (09:22)
- SUMMARIZE and SELECT Functions (22:26)
- CROSSJOIN Function (33:30)
- GENERATE Function (36:22)
- Tables, Relationships and Data Lineage (39:11)
- ROW, LOOKUPVALUE, and CONTAINS Functions (45:20)
- TOPN Function (48:10)
- UNION, INTERSECT, and EXCEPT Functions (53:17)
- SUMMARIZECOLUMN and GROUPBY Functions (59:37)
- Query Measures (62:57)
- Parameters in Queries (65:23)
- DAX Measures in MDX Queries (66:25)
- Querying in DAX Summary (68:14)
- Lab 6 (69:02)
Comments
hxy0135 · 17 February 2018
Hi Dear Instructor,
In MDX, we can use Generate() to create a NamedSet to be used as rows in a report. What is the use for the result returned by Generate() in DAX since Tabular does not support NamedSet?
thank You!
Marco Russo · 18 February 2018
It is used to generate tables within a complex DAX Expression.
There are many possible use cases, you can find a few of them here: https://www.sqlbi.com/articles/using-generate-and-row-instead-of-addcolumns-in-dax/