In this chapter, we looked at the DAX formula editor in Power BI Desktop, including a look at some of the shortcut key combinations you can use to help when typing in DAX expressions. We looked at Excel Power Pivot and learned how to use it to build a data model inside an Excel workbook, much like we did using Power BI Desktop. We then learned how to import that data model into an SSDT project and how to extend it using DAX. We then deployed the data model to an instance of SSAS Tabular. Finally, we learned how to query the data once it was in the SSAS Tabular database, using SSMS.
In the next chapter, we will return to the subject of the evaluation context, moving beyond what we learned in Chapter 1, What is DAX? We will take a more in-depth look at the difference between the row context and the filter context, and how these affect DAX functions.