Start your self-paced DAX study today and get from zero to hero in a month!
- Publication date: May 10, 2019
- Size: 220 pages, 7.5″ x 9.25″
- Price: $34.99
- ISBN 10: 1-7330461-0-0
- ISBN 13: 978-1-7330461-0-7
Introduces data analysts and developers to Data Analysis Expressions (DAX) — the programming language Microsoft Power BI, Power Pivot, and Analysis Services Tabular.
You won’t get far with Microsoft BI without DAX. However, DAX has been perceived as difficult to learn. Not anymore! This guide will help you master the major DAX concepts and get you from zero to hero in no time!
Synopsis
As its name suggests, the main objective of this book is to teach you the practical skills to take the most out of DAX from whatever angle you’d like to approach it. It’s written for data analysts using Power BI or Power Pivot, BI developers targeting Analysis Services Tabular, and in general, anyone who’s interested in DAX. You’ll learn DAX methodically, with self-paced lessons that build upon your previous knowledge and introduce more challenging concepts progressively. Each lesson starts with providing the necessary theoretical background, followed by step-by-step exercises. Most lessons are five to six pages long, and it should take you no more than 15 minutes to complete the practices. Do one lesson per day and become a DAX expert in a month!
This page provides sample chapters, source code, and a discussion forum where the author welcomes your feedback and questions.
What’s inside
- Extend your models with custom columns
- Implement important business metrics and key performance indicators
- Create custom queries to explore data and test measures
- Apply advanced relationships and data security
…and much more!
Resources
 Front matter |
Sample chapter |
Forum |
| Index |
Source code |
|
| Back cover |
Errata |
Reviews
“This book fills a gap for the new users of Power BI (or Power Pivot) who’ve taken a stab at writing DAX (either via Power Pivot or Power BI) and are now ready to fill in some beginner-blanks and learn the correct mindset for how and when to use DAX along with some common business calculation patterns.”
SSAS / Power BI Consultant
Hi Teo,
Reading and going through Applied Dax with Power BI. I am working through Getting Started with Vertipaq Analyzer. I have followed steps: put in Port from Dax studio selected the only available unique identifier hit test connection and got following error:
“Test Connection Failed because of an error in setting the window handle property. Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Continue with Test Connection?”
I hit OK and then got another error
“Test connection failed because of an error in initializing provider …… No connection could be made because the Target machine actively refused it.”
I am enjoying the book so far.
Thanks,
Rob Wolf
Hi Teo,
I am slowly going through your book. A little bit each day. Though I have been using DAX for a while and actually I am the main supplier of BI in my company having created many reports and visuals with with well over a hundred measures. The people at my company think I am an expert. In reality I am just a beginner. I guess it shows the power of the tool. I am on page 91 working with variables. I don’t understand how the All(DimDate) is working. I suppose it is just another filter (actually a remove filter) in the calculate formula. I see when I remove it the amount is not correct, but I don’t understand why. Is it because the filter is not on the Date that is needed to get the proper Sales Amount.
I am finding your book helpful.
Thanks,
Rob
Question on pg. 7 (Kindle Edition):. 1.(Optional) Click the Report View tab in the navigation bar. Create a visual that uses the DimCustomer[FullName] column (or refer to the Calculated Column visual in SourceIntroAdventure Works).
When I downloaded the source code from this page, it starts with Part1. There’s no Intro folder in Source. Did I miss something?
Hi Kirsten,
It should be SourcePart1Adventure Works, sorry. I’ll update the errata.
Thanks for the response!
Hello there, where is the link to download the sources that the book says on the preface?
Hi Levi,
Thank you for being a reader. The download link can be found on the book page (https://prologika.com/daxbook/). Scroll down and click the “Source code” link. The direct link is https://prologika.com/wp-content/uploads/1733046100/resources/dax_source.zip
Thanks a lot!!!
in the Power bi files I get the following source error
DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
Details:
DataSourceKind=SQL
DataSourcePath=elite2;AdventureWorksDW2017
Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
ErrorCode=-2146232060
Hi Terry,
Which exercise is this? Are you trying to refresh tables?
It’s the power bi files in the applied Dax for power bi book. As I understand from other forums we can’t refresh data and only use the files for dax measures. Is that correct ?
Which exercise (page) are you referring to? There is no need to refresh the models because DAX measures are runtime calculations. So, the cached data is all you need.
I have just purchased the Applied DAX text and the sources will not open after download. Help
Hi, the download link (https://prologika.com/wp-content/uploads/1733046100/resources/dax_source.zip) will download a zip file to your computer, which you need to unzip to a folder of your choosing. This is explained in more detail on page xiii in the book front matter.
p25- collecting statistics. When I change the local host I lose all access to the data. I've tried keeping the host number with the example provided in the start up folder and changing it to the number shown in DAX for my connection- but nothing. It just goes into error mode- don;t worry. SORTED 🙂
guidance requested – In Lesson 7, on below Practice where reference to second (another) column in CALCULATE filter is said to throw error, I am not having that error [when replacing [OrderDate] with [ShipDate], so something I am missing. Please guide. [also the Note in the same kindle location seem reaffirms above – and apparently also seem to contradict a community post pasted below the book snap ]
https://uploads.disquscdn.com/images/d9fcc2d3c14eebc3f1f1029251ffe4756750926e31c16c6bc6338891b001066b.png https://uploads.disquscdn.com/images/de0b9b1feb97a9f52e61982f8eeb3b62dfe7ee537293112e0e6ca0675a6beb96.png
Hi Ahmad,
The CALCULATE function in Power BI started supporting the OR filter on multiple columns with the September 2021 release of Power BI Desktop. This enhancement allows users to apply multiple filters using the OR (||) logical operator.
In Figure 8.5, seems a typo in Kindle version but correct in accompanying Power BI Desktop file. bars seem switched for 2nd and 3rd category between 21-40 and 61&above https://uploads.disquscdn.com/images/2f28b284afb5c1eeb24907d1d8113a12df4514199877dfba34fe4234d777ea9b.png
Hm, a good catch. Not sure what happened to that graph. I'll update the errata.