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
  • 180 Pages
  • Publisher: Holy Macro! Books
  • 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 Bookstore

eBook from MrExcel

Add to Cart »

Amazon

Print book from Amazon

Buy Now »

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


M is for (DATA) MONKEY

December 2015

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.


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.


Supercharge Power BI

February 2018

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.