DAX Quiz

What does DAX stand for?

• Data Analysis XML

• Data Analysis Expressions

• Data Analytics Exchange

• Data Aggregation Expressions

Which of the following is NOT a category of DAX functions?

• DateTime

• Statistical

• Logical

• Geospatial

In DAX, what is the main purpose of a measure?

• Store static values in a table

• Dynamically calculate results based on report context

• Create relationships between tables

• Store formatting rules for visuals

Which icon identifies a measure in Power BI?

• A table icon

• A function icon

• A calculator icon

• A filter icon

Which DAX function would you use to find the most expensive order?

• SUM()

• AVERAGE()

• COUNT()

• MAX()

What does the DISTINCT() function return in DAX?

• The highest value in a column

• The sum of all values in a column

• Unique values from a column

• The count of rows in a table

How can you organise multiple measures in Power BI?

• By creating slicers

• By creating display folders

• By sorting columns

• By grouping visuals

What is a calculated column in DAX?

• A column containing only numbers

• A column added to a table with values generated by a formula

• A hidden column used for measures

• A default field created by Power BI

Which of the following is a comparison operator in DAX?

• &&

• ^

In DAX, using the concatenation operator (&) with numbers will produce:

• The sum of the numbers

• The product of the numbers

• A text value

• An error