# Learn to Write DAX

December 2015

## 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
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

MrExcel Bookstore

eBook from MrExcel

Amazon

Print book from Amazon

### Other Editions

April 2018

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

### Related Products

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.

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.