Applied DAX with Power BI

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 https: //prologika.com/daxbook provides sample chapters, source code, and a discussion forum where the author welcomes your feedback and questions.

WHAT'S INSIDE: CALCULATED 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 patterns and much more ...