Skip main navigation

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:

This article is from the free online

Microsoft Excel: Advanced Data Analysis and Visualisation

Created by
FutureLearn - Learning For Life

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.

Start Learning now