Introduction to DAX in Power BI Quiz

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