DAX interview questions
40 questionsMeasures, CALCULATE, filter context and time intelligence on a star schema. Answers are checked against Power BI Desktop.
Measure basics
Iterators and row context
CALCULATE and filter context
Time intelligence
Ranking and table queries
Interview classics
- Running totalHard
- Quarter to dateEasy
- Year to date for last yearHard
- Fix a measure that repeats the same totalEasy
- Share of the visible totalMedium
- Count using RELATEDTABLEMedium
- COUNTA and blanksEasy
- Dense rankMedium
- Customers active in two yearsHard
- New customers in a periodHard
- Sales of the top three productsHard