Extending Your Data Model with DAX Calculations
Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana · Apress eBooks · 2020
As part of the data modeling process, Power BI gives us access to a language called DAX or the Data Analysis Expression language. DAX allows us to expand the analytical power of our data model with the creation of calculated columns, calculated measures, and calculated tables. Each of these items is created using DAX which is a user-friendly language that has parallels to the Excel formula language. In this chapter, we will gain an understanding of the differences between calculated columns, calculated measures, and calculated tables. In the “Try It Out” section, we will extend the model we have been working with by adding calculated columns and calculated measures.