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