Querying with DAX Purchase the entire course
Mastering DAX Workshop
Jump to a chapter
- Working With Tables and Queries (00:08)
- EVALUATE (10:20)
- CALCULATETABLE (14:27)
- SELECTCOLUMNS (30:04)
- SUMMARIZE (39:14)
- SUMMARIZECOLUMNS (45:51)
- CROSSJOIN (52:13)
- TOPN and GENERATE (58:14)
- ROW and DATETABLE (66:48)
- Tables and Relationships (74:31)
- UNION, INTERSECT and EXCEPT (81:12)
- GROUPBY (96:38)
- Query Measures (104:34)
You can use DAX to create calculated columns and measures, but you can also use DAX as a query language. 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 several table functions useful in both queries and other DAX expressions.
This module has a lot to offer! We start with functions that filter rows, such as: FILTER, CALCULATETABLE, and TOPN. Then, we advance onto functions that group rows and project columns, such as: SUMMARIZE, SUMMARIZECOLUMNS, GROUPBY, and SELECTCOLUMNS. Table manipulation functions which we subsequently cover include: CROSSJOIN, GENERATE, UNION, INTERSECT, and EXCEPT. Finally, we discuss a few utility functions including: ROW, LOOKUPVALUE, and CONTAINS.
Towards the end of this module you will learn how to create measures local to a query. This technique will increase your productivity while you are developing and testing new measures.
Overall, this module will show you plenty of techniques that you are likely to need in the real world.
Log in or purchase access to play the video.
Purchase a Full Access Subscription
- You can also redeem a prepaid code.
- Payments are instant and you will receive a tax invoice straight away.
- We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
- See pricing FAQ for more detail.
