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.

This is the second edition of the number 1 selling Power Pivot Book. This expanded 2nd edition includes DAX, Power Query, Power BI Desktop, PowerBI.com. Covers Excel 2010 through Excel 2016