Marco Russo, renowned for his deep knowledge of Data Analysis Expressions (DAX), a book author on the subject, and a consultant with sqlbi.com has just published his newest video, Querying with DAX, part of our online DAX learning series. In this 46–minute video, which includes 7 detailed demos, Marco shows you how to use DAX for querying a data model, which is useful for building reports or creating advanced Excel tables. Typically, you would use DAX for building calculations, such as new ﬁelds or measures, but it turns out that the DAX langauge lends itself well to powerful—and fast—queries, that previously would have required you to use MDX, or T-SQL.
Follow this video to learn about EVALUATE, CALCULATETABLE, SUMMARIZE, ROLLUP, ADDCOLUMNS, and ROW functions, amongst other topics. See how to use DAX Studio, a free add-in for Excel, to test your expressions, and how to use other tools available for writing DAX queries, even when using DAX in an MDX query.
Please note, this video is available to Full Access Members only. A membership is inexpensive, and you can watch everything as many times as you want, while your membership is current, and we add brand-new, high quality content every month.