Learn to Write DAX

December 2015

Learn to Write DAX

Power Pivot in Excel 2010/2013 is Better When You Learn to Write DAX!

A practical guide to learning Power Pivot for Excel

category: Power Pivot
covers: Excel 2013

Product Details
  • 180 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-041-9
  • PDF ISBN: 978-1-61547-231-4

Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

This book is written to give you exactly that – hands-on practice. Inside you will find explanation of concepts, sample exercises and then practice questions and answers to maximize learning retention and experience.

  1. Concept: Pivot Tables vs. Power Pivot
  2. Concept: Loading Data
  3. Concept: Calculated Fields
  5. Concept: Filter Propagation
  6. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  7. DAX Topic: Calculated Columns
  8. DAX Topic: CALCULATE()
  9. Concept: Evaluation Context and Context Transition
  10. DAX Topic: IF(), SWITCH(), and FIND()
  11. DAX Topic: VALUES() and HASONEVALUE()
  12. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
  13. DAX Topic: FILTER()
  14. DAX Topic: Time Intelligence
  16. Concept: Disconnected Tables
  17. Concept: KPIs and Multiple Data Tables
  18. Concept: Cube Formulas
  19. Moving from Excel to Power BI
  20. Next Steps on Your DAX Journey
  21. Appendix A: Answers to Practice Exercises

Where to Buy

MrExcel Bookstore

eBook from MrExcel


Print book from Amazon

Other Editions

Supercharge Excel When You Learn to Write DAX For Power Pivot

April 2018

Hands-on book to learn and master the DAX language!

Related Products

Power Pivot and Power BI

January 2016

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.