/
DAX Basics and Concepts
Save to my account
Sign up
DAX Basics and Concepts
DAX Basics and Concepts
Study
1
Question
Why is DAX more scalable than traditional Excel formulas?
Answer
Designed for large datasets; optimized for data modeling and analysis.
2
Question
Name the two main types of context in DAX.
Answer
Row context and filter context.
3
Question
What is a calculated column in DAX?
Answer
Computed during data load and stored in the model.
4
Question
What is a measure in DAX?
Answer
Dynamic calculation evaluated at query time.
5
Question
Why are measures often preferred for reporting in DAX?
Answer
More flexible and report-interaction friendly.
6
Question
Why is data type important in DAX calculations?
Answer
Prevents errors and ensures correct operations.
7
Question
What are common text data uses in DAX?
Answer
String manipulations and categorization.
