Home | Power BI | Excel | Python | SQL | Visualising Data | Generative AI
DAX Course Review Questions
Answer these questions. When the questsion ask for examples, show example DAX code from the case study that we have used in the course.
- What three types of objects can be created by a DAX expression? When would you use each type? – give examples
- What is the difference between aggregator and iterator functions? Give examples. When might you use an iterator rather than the corresponding aggregator?
- What is the difference between scalar and table functions? Give examples
- How does a calculated column differ from a measure? Give examples.
- What alternatives are there to implementing a calculated column in DAX?
- What alternatives are there to implementing a measure in DAX?
- What is an explicit measure? Which calculations are explicit measures? Why are they considered good practice?
- What is filter context? And row context?
- Explain briefly what these important DAX functions do
- CALCULATE()
- ALL()
- FILTER()
- KEEPFILTERS()
- Why use variables in DAX?
- Why are table functions sometimes useful in measures (which can only return a scalar value) Give examples?