The Definitive Guide to DAX: Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
by Marco Russo, Alberto Ferrari
Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
- Cover Page
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Foreword
- Acknowledgments
- Introduction to the second edition
- Introduction to the first edition
- Chapter 1. What is DAX?
- Chapter 2. Introducing DAX
- Chapter 3. Using basic table functions
- Chapter 4. Understanding evaluation contexts
- Chapter 5. Understanding CALCULATE and CALCULATETABLE
- Chapter 6. Variables
- Chapter 7. Working with iterators and with CALCULATE
- Chapter 8. Time intelligence calculations
- Chapter 9. Calculation groups
- Chapter 10. Working with the filter context
- Using HASONEVALUE and SELECTEDVALUE
- Introducing ISFILTERED and ISCROSSFILTERED
- Understanding differences between VALUES and FILTERS
- Understanding the difference between ALLEXCEPT and ALL/VALUES
- Using ALL to avoid context transition
- Using ISEMPTY
- Introducing data lineage and TREATAS
- Understanding arbitrarily shaped filters
- Conclusions
- Chapter 11. Handling hierarchies
- Chapter 12. Working with tables
- Chapter 13. Authoring queries
- Chapter 14. Advanced DAX concepts
- Chapter 15. Advanced relationships
- Implementing calculated physical relationships
- Implementing virtual relationships
- Understanding physical relationships in DAX
- Using bidirectional cross-filters
- Understanding one-to-many relationships
- Understanding one-to-one relationships
- Understanding many-to-many relationships
- Choosing the right type of relationships
- Managing granularities
- Managing ambiguity in relationships
- Conclusions
- Chapter 16. Advanced calculations in DAX
- Chapter 17. The DAX engines
- Chapter 18. Optimizing VertiPaq
- Chapter 19. Analyzing DAX query plans
- Chapter 20. Optimizing DAX
- Index
- Code Snippets
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.