DAX Cookbook
DAX is a library of functions and operators that can be combined to build formulas and expressions in Power BI Desktop, Azure Analysis Services, SQL Server Analysis Services, and Power Pivot in Excel. This book is a desk reference for people who want to leverage DAX's functionality and flexibility in BI and data analytics domains.
Offered by
Difficulty Level
Intermediate
Completion Time
18h24m
Language
English
About Book
Who Is This Book For?
Business users, BI developers, data analysts, and SQL users who are looking for solutions to the challenges faced while solving analytical operations using DAX techniques and patterns will find this book useful. Basic knowledge of the DAX language and Microsoft services is mandatory.
DAX Cookbook
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 18h24m total length
Thinking in DAX
Dealing with Dates and Calendars
Tangling with Time and Duration
Transforming Text and Numbers
Figuring Financial Rates and Revenues
Computing Customers KPIs
Evaluating Employment Measures
Processing Project Performance
Calculating Common Industry Metrics
Using Uncommon DAX Patterns
Solving Statistical and Mathematical Formulas
Applying Advanced DAX Patterns
Debugging and Optimizing DAX
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!