Summary

In this chapter, you learned about DAX concepts that are essential for mastering any job interview. First, I started by mentioning some points to take into account so that the learning process of this language is as fluid as possible. Then, we saw some of the basic aggregation functions such as MAX, MIN, and SUM, as well as some very practical examples of these functions. In the next section, we started by discussing the differences between measure and calculated columns and when you should use them.

Next, you saw a brief definition of what evaluation contexts are and the role played by the filter context and the row context inside measures. You also understood the importance of these to master the creation of complex measures using DAX. In the final stretch, you also saw some time intelligence functions, as well as some very useful examples that taught you how to go back and forth in time with these functions.

Finally, I showed you some advanced concepts about DAX and...