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:

• SUMX
• CALCULATE
• DIVIDE
• ALL