Creating and Formatting Measures
In this video, Dany introduces you to some very important functions in the DAX language.
Make sure you have a good understanding of them and to supplement your new knowledge, check out the additional resources below.
Once you feel comfortable with the content, attempt the quiz in the next step to test your knowledge.
Lecture Files
The file used in the lecture is provided here: “The Excel data model.xlsx“. If you are using Excel 2010, use this file instead: “The Excel data model (2010).xlsx“.
Further Reading
Recall that context was discussed in Week 1. For a refresher on this important concept, review this Microsoft Office Article: Context in DAX Formulas: Context in DAX Formulas
For more information about the DAX functions explained in this lecture, check out the following resources:
Microsoft Excel: Advanced Data Analysis and Visualisation
Microsoft Excel: Advanced Data Analysis and Visualisation
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
