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 available for purchase globally. The eBook is available for immediate download by clicking one of the tiles below.

If you purchase the Paperback from my shop (link with the Aussie map) or from Mr Excel (link with the USA map) you will receive a DRM free copy of the eBook as well (immediate download) at no extra charge. Alternatively you can purchase the book from Amazon USA and also most other Global Amazon stores.

Would you rather Supercharge Power BI?

My new book Supercharge Power BI: Power BI is Better When you Learn to Write DAX covers the same learning experience as covered in this, my first book, and hence it can be considered a sister book. These two books use the same content, teaching, and practice format but with different software versions, as indicated in the titles. You should choose the best book for you given which software product you want to use.

I have taken my 30+ years experience using Excel and also my experience in teaching live Power Pivot classes and distilled this knowledge into a book that will help any Excel user get started with Power Pivot, DAX and Power BI.  The challenge with Power Pivot is that it is completely different to the rest of Excel.  As a result, you can’t just ‘incrementally learn’ this stuff off the base of your existing Excel skills – you really need to do some formal learning to get started. This book is exactly what you need to get that start.

Once you have read my book and completed the exercises there will be no stopping you on your path to DAX, Power Pivot and Power BI super stardom.


Preview the book on Amazon

You can preview the book (shown below) live at Amazon to take a peek inside. But don’t forget if you buy the book from my store as an ebook or paper back, you get 3 different ebook file formats without digital rights management so you can load to all your devices. Of course the material is still copyright but we want you to be able to use the book the way that works for you.

Reviews on Amazon

Here are a few of the comments.

“This book is awesome!”. “This is the 3rd book in my newly established “DAX” collection and frankly, I should have bought this book first.” – Tom

A very good way to make the transition from standard excel user to an modern excel user is to buy this book”. – Rafael Paim.

“This is the book to start with if you are beginning your DAX writing journey. In my opinion, Matt’s approach to helping people learn how to write DAX is superior to any of the other DAX books I have read.” – John M. McNally.

“I’ve read many well-written computer books in my career, but, Learn to Write DAX, by Matt Allington, truly stands out.” – Frank Quarry

“I’m only 1/2 half the way through and already feel that I good grasp of DAX formulas and usage. Best BI book I’ve purchased in a while!!” – Robert Spaeth.

“This book is fantastic!” – Suum Cuique.

“The genius of this book is that Matt perfectly understands how our Excel minds work!” – Amazon Customer

You can read all the reviews from Amazon here.

Feedback from Readers.

“I purchased your eBook last Saturday and I want to let you know that I have learned more in the last 96 hours than I have in the last 3 months. I have a number of books on DAX, but since I am a novice your book has begun to provide the basics and increased an understanding in a structured manner.”  Kevin

“I am greatly enjoying working through your book, “Learn to Write DAX”.  I am wrapping up Chapter 8 right now and it is in my opinion the best resource out there for teaching someone how to actually integrate DAX skills into a project, incorporating all of the necessary elements and skills as opposed to many of the other “piece meal” instructional resources available that although good, teach individualized concepts but lack the integration of the pieces into a coherent whole.”  Brian

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. A copy of the sample database is included in the eBook download, so you will not need to download this file if you have purchased the eBook from my shop. For those purchasing a hard copy of the book, you can download the sample database here.

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

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!