Chapter 7: Creating Measures Using DAX
Once you have connected to your data, done a bit of analysis, and organized it for reporting, the next step is to create a data model.
A good data model will provide faster and more accurate reporting. If the data model is easy to understand, report developers will take less time to generate reports and it will make those reports easier to maintain. The data model is a crucial component of any Power BI solution, so ensuring you have effective and efficient use of measures will be a key factor. In this chapter, we will take a deep dive into the powerful Data Analysis Expressions (DAX) programming language, which will unlock dynamic and useful capabilities for solving reporting challenges.
In this chapter, we will cover the following topics:
- Building complex measures with DAX
- Using
CALCULATEto manipulate filters - Implementing time intelligence using DAX
- Replacing numeric calculated columns with measures
- Using basic...
