Overview

Data analysis expressions (DAX) is the formula language of Power BI. Learning the DAX language is key to empower Power BI users so they can take advantage of these new Business Intelligence (BI) capabilities. This volume clearly explains the concepts of DAX while at the same time offering hands-on practice to engage the reader and help new knowledge stick. This third edition has been updated for the new Power BI Ribbon interface while still providing a bridge for readers wanting to learn DAX in the Power BI, Power Pivot, or Excel. Updated for new Power BI User Interface.

Full Product Details

Author:   Matt Allington
Publisher:   Holy Macro! Books
Imprint:   Holy Macro! Books
Edition:   Fourth edition
ISBN:  

9781615470846

ISBN 10:   1615470840
Pages:   346
Publication Date:   31 May 2024
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   Not yet available  
This item is yet to be released. You can pre-order this item and we will dispatch it to you upon its release.

Table of Contents

Introduction 1: Concept: Introduction to Data Modelling 2: Concept: Loading Data 3: Concept: Measures 4: DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE() 5: Concept: Filter Propagation 6: Concept: Lookup Tables and Data Tables 7: DAX Topic: The Basic Iterators SUMX() and AVERAGEX() 8: DAX Topic: Calculated Columns 9: DAX Topic: CALCULATE() 10: Concept: Evaluation Context and Context Transition 11: DAX Topic: IF(), SWITCH(), and FIND() 12: DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX() 13: DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED() 14: DAX Topic: FILTER() 15: DAX Topic: Time Intelligence 16: DAX Topic: RELATED() and RELATEDTABLE() 17: Concept: Disconnected Tables 18: Concept: Multiple Data Tables 19: Concept: Using Analyze in Excel and Cube Formulas 20: Transferring Your Skills to Excel 21: Next Steps on Your DAX Journey

Reviews

Author Information

Matt Allington is an Microsoft Data Platform MVP that specialises in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and also having spent 10 years working in IT roles supporting business users to get the data they need. It is the combination of this work history and Matt's rare skill and ability to clearly explain technical concepts that make this book such a valuable stand-alone learning resource. Matt Allington is an Microsoft Data Platform MVP that specialises in teaching and helping business users leverage the Power BI suite of tools to achieve positive business outcomes. Matt has a unique work experience history having spent 15 years working in commercial roles using data, and 10 years working in IT roles supporting business users to get the data they need. It is the combination of this work history and Matt's rare skill and ability to clearly explain technical concepts that make this book such a valuable stand-alone learning resource.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions