Supercharge Excel: Learn How to Write DAX for Power Pivot
1146343456
Supercharge Excel: Learn How to Write DAX for Power Pivot
14.99 In Stock
Supercharge Excel: Learn How to Write DAX for Power Pivot

Supercharge Excel: Learn How to Write DAX for Power Pivot

by MrExcel's Holy Macro! Books, Matt Allington
Supercharge Excel: Learn How to Write DAX for Power Pivot
Add to Wishlist
Supercharge Excel: Learn How to Write DAX for Power Pivot

Supercharge Excel: Learn How to Write DAX for Power Pivot

by MrExcel's Holy Macro! Books, Matt Allington

Product Details

ISBN-13: 9781836646747
Publisher: Packt Publishing
Publication date: 09/26/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 219
File size: 16 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Matt Allington is a Microsoft Data Platform MVP specializing in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and 10 years working in IT roles supporting business users to get the data they need. A combination of this work history and Matt's rare skill and ability to clearly explain technical concepts makes this book such a valuable stand-alone learning resource.

Table of Contents

Table of Contents
  1. Concept: Introduction to Data Modelling
  2. Concept: Loading Data
  3. Concept: Measures
  4. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  5. Concept: Filter Propagation
  6. Concept: Lookup Tables and Data Tables
  7. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  8. DAX Topic: Calculated Columns
  9. DAX Topic: CALCULATE()
  10. Concept: Evaluation Context and Context Transition
  11. DAX Topic: IF(), SWITCH(), and FIND()
  12. DAX Topic: VALUES() and HASONEVALUE()
  13. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
  14. DAX Topic: FILTER()
  15. DAX Topic: Time Intelligence
  16. DAX Topic: RELATED() and RELATEDTABLE()
  17. Concept: Disconnected Tables
  18. Concept: KPIs
  19. Concept: Multiple Data Tables
  20. Concept: Cube Formulas
  21. Moving from Excel to Power BI
  22. Next Steps on Your DAX Journey
From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Applications & Software
Spreadsheets
Computers
Applications & Software
Spreadsheets

Customer Reviews