PowerPivot Workbook for Learning DAX
If you would like to follow Marco and Alberto’s demos, you will find it easier if you use the same data as they do in the video. This workbook already contains calculated columns and measures created in the video. You can create new ones or remove the existing ones and creating the same ones as you have seen in the video. We offer this workbook as a free bonus for Full Access Members who are following our DAX online course.
Log in or purchase access below to the premium version of this content.
Hierarchies in DAX
DAX: Data Analysis Expressions (Older)
1.
DAX in Action! 19-minFree
2.
DAX: Calculated Columns vs. Measures 11-minFree
3.
Introduction to DAX in Excel 37-min
4.
DAX Evaluation Context 51-min
5.
DAX: The CALCULATE Function 47-min
6.
Querying with DAX 46-min
7.
What is Time Intelligence? 2-minFree
8.
DAX Time Intelligence 1-hour
9.
Many-to-many Relationships in DAX 3-minFree
10.
DAX Patterns: Banding, New vs Old, Many-to-many 51-min
11.
How to Calculate with Hierarchies in DAX? 1-minFree
12.
Hierarchies in DAX 54-min
13.
DAX AW Sample Data Set
Purchase A Full Access Subscription
- Payment is instant and you will receive a tax invoice straight away.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
Comments
arthurjenkins1969 · 6 January 2013
Hello Marco. I have downloaded the DAX AW Data Set but it does not seem to work correctly in Excel 2013. Is there any reason why this might be so?
Thank you.
Arthur Jenkins
Marco Russo · 8 January 2013
Arthur,
I just tried it and it works.
When you open the workbook, you have to confirm that you want to upgrade the PowerPivot data to the new version - this happens as soon as you try to open the PowerPivot Manage window.
Please let me know if it works to you, or what error you have if otherwise.
Thanks,
Marco
qwiksilver96 · 16 July 2014
Marco, I too have the same issue as Arthur Jenkins. Running Excel 2013 and get notified that the data model needs to be upgraded. Upon clicking OK, I receive the following error: "PowerPivot is unable to load the Data Model".
Thank you,
Frank
Marco Russo · 16 July 2014
Frank,
you have to extract the file from the original ZIP first. After you extracted and saved the Excel file in a folder, you open the file in Excel and the upgrade works.
What you described seems the behavior you have by opening the file directly from the ZIP file (it's saved in a temp directory but you cannot upgrade in that case).
Marco