MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
  • Paperback: 180 Pages
  • Publisher: Holy Macro! Books
  • Print ISBN: 978-1-61547-041-9
  • PDF ISBN: 978-1-61547-231-4
  • ePub ISBN: 978-1-61547-354-0
  • Mobi (Kindle) ISBN: 978-1-61547-131-7

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
  4. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  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
  15. DAX Topic: RELATED() and RELATEDTABLE()
  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 Store

We will ship you a physical copy of the book, plus you can immediately download the e-book in any of three DRM-Free versions: PDF, ePub, or Mobi.

Print Book from MrExcel »

MrExcel Store

Outside of the USA, purchase the e-book. Again, you can choose from any of 3 DRM-Free editions when you purchase from:

e-Book from MrExcel »

Amazon.com

Print Book from Amazon:

Print Book from Amazon »

Related Products