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
Add to Cart: $14.99 »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.
- Concept: Pivot Tables vs. Power Pivot
- Concept: Loading Data
- Concept: Calculated Fields
- DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
- Concept: Filter Propagation
- DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
- DAX Topic: Calculated Columns
- DAX Topic: CALCULATE()
- Concept: Evaluation Context and Context Transition
- DAX Topic: IF(), SWITCH(), and FIND()
- DAX Topic: VALUES() and HASONEVALUE()
- DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
- DAX Topic: FILTER()
- DAX Topic: Time Intelligence
- DAX Topic: RELATED() and RELATEDTABLE()
- Concept: Disconnected Tables
- Concept: KPIs and Multiple Data Tables
- Concept: Cube Formulas
- Moving from Excel to Power BI
- Next Steps on Your DAX Journey
- Appendix A: Answers to Practice Exercises
