This course contains exercises for the JourneyTEAM Advanced DAX course.

The associated Power BI Desktop (.pbix) and data files with this workbook can be downloaded at http://bit.ly/AdDAXcontent.

Save the zipped file Course Content.zip to your computer and extract the files.

Once you download and unzip the data you will need to change the data source in Power BI to your local machine. To accomplish this, follow the steps below:

1.    In Power BI Desktop, go to Edit Parameters in the Transform Data dropdown

2.    Paste the file path of the folder where you extracted the data

3.    Click OK

4.    Close the window

5.    Refresh your data

Each section in this workbook contains step-by-step instructions followed by a solutions subsection called Check Your Code. To get the most out of this workbook, wait to look at the Check Your Code section until you have tried to write the DAX on your own.

Enjoy!