Supercharge Excel (includes free digital copy)
Supercharge Excel – When You Learn To Write DAX for Power Pivot is the second edition of Learn to Write DAX that was the most preferred DAX book. The first edition was based on Excel 2013 while the second edition is on Excel 2016.
Data analysis expressions (DAX) is the data modelling language of Excel Power Pivot and Power BI. DAX language and DAX functions are the same in both Excel and Power BI and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces.
Simply reading a regular book is normally not enough to help users to learn DAX skills – you need to complete the exercises and get plenty of practice to make the transition. This book is written to give you exactly that – hands-on practice. Inside you will find explanation of the concepts, sample exercises and then practice questions and answers to maximise learning retention and experience.