These references apply to the development of Power Pivot data models in Excel, SSAS Tabular data models, and Power BI data models
From Alberto Ferrari, one of the world’s subject matter experts on the topic of DAX, “7 Reasons DAX is Not Easy“. He says, “DAX is simple, but it is not easy.”
See also my Power BI homepage on this site
- ALM Toolkit
- Analyze in Excel for Power BI Desktop
- BISM Normalizer
- DAX Editor
- DAX Studio
- DAX Formatter
- DAX Date Template
- Power Pivot Utilities
- SSAS Events Analyzer
- SSAS Tabular Translator
- Tabular Editor
- Best Practices Analyzer – Best Practice Rules for Tabular Editor on GitHub
- VertiPaq Analyzer
Power BI Helper, now version 12, from RADACAD (I pulled the picture below directly from the RADACAD website.
 Intro to Data Modeling for Power BI |  Introducing DAX |
 DAX Tools Video Course | |
| Beginning DAX Concepts with Power BI (2:54:14) | by Mitchell Pearson at Pragmatic Works |
| Advanced DAX | by Mitchell Pearson at Pragmatic Works |
| Evaluation Contexts in DAX | by Matt Allington of Excelerator BI in Australia |
| DAX Measures: Filter Context Explained in Simple Terms using the I.C.A.N. Principle | by Avi Singh [Part 1] |
| Filter Context – (1.9) Ultimate Beginners Guide to DAX | by Sam McKay at Enterprise DNA in Australia |
| Elements of DAX (multi-part series) | with Brian Grant of CSG Pro |
 Supercharge Power BI – Power BI is Better When You Learn to Write DAX by Matt Allington Click here to buy. |  Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv |  Exam Ref 70-778, Analyzing and Visualizing Data with Microsoft Power BI by Daniil Maslyuk |  Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model by Marco Russo, Alberto Ferrari, and Chris Webb |
 The Definitive Guide to DAX – Second Edition by Marco Russo and Alberto Ferrari | FREE! Introducing Microsoft Power BI by Alberto Ferrari and Marco Russo | FREE! Power BI from Rookie to Rock Star by Reza Rad |
DAX Patterns from SQLBI
- A few select references from SQLBI…
- 7 Reasons DAX is Not Easy (“DAX is simple, but it is not easy.”)
- Row Context and Filter Context in DAX
- Understanding Context Transition
- Apply DAX basics in Power BI Desktop from the Power BI documentation, several important subtopics
- Stairway to DAX and Power BI (15 part series, at last count) by Bill Pearson at SQLServerCentral
- Stairway to SSAS Tabular by Thomas LeBlanc at SQLServerCentral
- Free sample chapter, “Understanding Evaluation Contexts in DAX” from “The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI” By Alberto Ferrari and Marco Russo
- DAX Date Calculations Cheat Sheet by Arthur Graus at I Love Power BI
- Multiple Data Tables in Power Pivot by Matt Allington at ExceleratorBI {introduces The Collie Layout Method}
- Giving Back: Steal this Reference Card! by Rob Collie at PowerPivotPro (P3)
- DAX – The Diabolical Genius of “SWITCH TRUE” by Rob Collie at P3
- Beginning DAX Concepts with Power BI by Mitchell Pearson of Pragmatic Works {not really beginning. Very good. Almost three hours]