WorksheetsIntroduction to DAX in Power BI Quiz
Total questions: 8
Worksheet time: 4mins
What is DAX in Power BI used for?
DAX in Power BI is used for formatting the appearance of reports.
DAX in Power BI is used for creating visualizations only.
DAX in Power BI is used for importing data from external sources.
DAX in Power BI is used for creating custom calculations and measures in data models.
What are arithmetic operators used for in DAX?
Arithmetic operators in DAX are used for comparing values
Arithmetic operators in DAX are used for concatenating strings
Arithmetic operators in DAX are used for creating conditional statements
Arithmetic operators in DAX are used for performing mathematical operations such as addition, subtraction, multiplication, and division on numerical values.
Give an example of a logical operator in DAX.
&
??
&&
!
What is the purpose of comparison operators in DAX?
Comparison operators in DAX are used to compare values and return a true or false result.
Comparison operators in DAX are used to create new variables
Comparison operators in DAX are used to perform mathematical calculations
Comparison operators in DAX are used to concatenate strings
Explain the process of creating measures in DAX.
To create measures in DAX, you need to use the DAX formula language to write expressions that define the calculation logic.
To create measures in DAX, you need to use the JavaScript formula language
To create measures in DAX, you need to use the SQL formula language
To create measures in DAX, you need to use the Python formula language
Which of these Dax operators is not arithmetic?
^ (exponentiation)
+ (addition)
% (modulus)
/ (division)
How do you use logical operators in DAX to filter data?
By using mathematical operators such as +, -, and * in DAX.
By using logical operators such as IF, THEN, and ELSE in DAX.
By using comparison operators such as =, <>, and >= in DAX.
By using logical operators such as AND, OR, and NOT in DAX.
Compare and contrast logical and comparison operators in DAX.
In DAX, logical operators are used for logical operations like AND, OR, and NOT, while comparison operators are used to compare values.
Logical operators are used for mathematical operations
Comparison operators are used for logical operations
Logical operators are used to compare values
