Applied DAX with Power BI: From zero to hero with 15-minute lessons

by Teo Lachev

Written by a Microsoft MVP, this book teaches you the practical skills to take the most of DAX from whatever angle you'd like to approach it. It's written for data analysts using Power BI or Power Pivot, BI developers targeting Analysis Services Tabular, and in general anyone who's interested in DAX. You’ll learn DAX methodically with self-paced lessons that build upon your previous knowledge to introduce progressively more challenging concepts. Each lesson starts with providing the necessary theoretical background, followed by step-by-step exercises. Most lessons are five to six pages long, and it should take you no more than 15 minutes to complete the practices. Do one lesson per day and become a DAX expert in a month!The book page at provides sample chapters, source code, and a discussion forum where the author welcomes your feedback and questions.WHAT'S COLUMNSCreate custom columnsNavigate relationshipsAssemble dashboards with a few clicksAggregate and rank dataImplement grups and binsCreate calculated tablesMEASURESImplicit and explicit measuresWork with user selectionCreate variablesOverwrite filter contextGroup dataApply time intelligenceQUERIESCreate and test DAX queriesImplement query measuresAnalyze query performanceImplement paginated reportsADVANCED TOPICSRecursive relationshipsMany-to-many relationshipsVirtual relationshipsDifferent join typesData security patternsand much more ...

222 pages, Kindle Edition

Published May 10, 2019