Learn to Write DAX

Jump directly to the access Adventure Works Database Download.

Learn to write DAX – A Practical Guide to Learning Power Pivot for Excel and Power BI is my first book on DAX (now superceded).  This book teaches readers how to get the most out of Power Pivot for Excel 2013 by learning the DAX language. This book gained popularity as the first book to read to learn DAX.

Supercharge Excel: When You Learn to Write DAX for Power Pivot  is the second edition and current of this book. This updated version covers the same learning experience and exercises as covered in my first book but is updated using Excel 2016.

Supercharge Power BI: Power BI is Better When you Learn to Write DAX covers the same learning experience as covered in Supercharge Excel, and hence it can be considered a sister book.  Supercharge Power BI is written using Power BI Desktop.


If you are starting afresh to learn to write DAX, I suggest to opt for Supercharge Excel. If you are on the path of becoming a master of the self-service tool Power BI Desktop, I suggest to opt for Supercharge Power BI.

However if you use Excel 2013, this book is still a good fit. You can purchase the paperback of this book from my shop and you will get an immediate download of the 3 eBooks (as given above) for free.

If you enroll to my Supercharge Power BI Online Training, you will get a copy of eBooks (Supercharge Excel and Supercharge Power BI) in addition to the weekly video lessons on complex topics and weekly Q&A sessions with me, Matt Allington.

Download the Sample Database

access You can download the sample database here so that you can complete the practice exercises in the book.  If you want to get any value from this book, you simply must complete the exercises.

Why not sign up to my blog at the same time in the form below.