Allington M. Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI

Allington Matt. Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI. – Holy Macro! Books, 2015. – 180p. ISBN10: 1615470417. ISBN13: 978-1615470419Архив ZIP включает книгу в формате PDF на английском языке и бд, которая используется в книге для примеров.Data analysis expressions (DAX) is the formula language of PowerPivot and this book is written to give hands-on practice to anyone who wants to become competent at writing such formulas. Sample exercises that explain each concept are provided and followed by practice questions and answers to maximize learning and experience with DAX.Concept: Pivot Tables vs. Power Pivot
Concept: Loading Data
Concept: Calculated Fields
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