Question 1

What does DAX stand for?

Accepted Answer

Data Analysis Expressions

Answer

Data Analytic Expressions

Answer

Data Analytic Execution

Answer

Data Analysis Execution

Question 2

Which function in DAX returns the sum of a column?

Accepted Answer

SUM()

Answer

TOTAL()

Answer

ADD()

Answer

SUMMARIZE()

Question 3

How do you calculate the average of a column in DAX?

Accepted Answer

AVERAGE()

Answer

MEAN()

Answer

AGGREGATE()

Answer

SUM() / COUNT()

Question 4

Which function would you use to create a calculated column?

Accepted Answer

CALCULATE()

Answer

GENERATECOLUMN()

Answer

ADDCOLUMN()

Answer

CREATECOLUMN()

Question 5

What is the purpose of the CALCULATE function in DAX?

Accepted Answer

Change the context in which data is evaluated

Answer

Summarize data

Answer

Filter data directly

Answer

Calculate arithmetic operations

Question 6

How do you get the distinct count of values in a column?

Accepted Answer

DISTINCTCOUNT()

Answer

COUNTDISTINCT()

Answer

DISTINCT()

Answer

COUNT()

Question 7

Which DAX function retrieves the current date?

Accepted Answer

TODAY()

Answer

GETDATE()

Answer

CURRENTDATE()

Answer

NOW()

Question 8

Which of the following functions would be used to concatenate two strings in DAX?

Accepted Answer

CONCATENATE()

Answer

JOIN()

Answer

MERGE()

Answer

COMBINE()

Question 9

What does the RELATED function do?

Accepted Answer

Fetch a related value from another table

Answer

Filters related data

Answer

Returns unique values

Answer

Creates relationships between tables

Question 10

Which DAX function would you use to create a measure?

Accepted Answer

NEWMEASURE()

Answer

ADDCOLUMN()

Answer

GENERATEMEASURE()

Answer

CREATE()

Question 11

What is the function of the ALLEXCEPT function?

Accepted Answer

Removes all filters except one

Answer

Removes all filters

Answer

Adds a filter

Answer

Keeps all filters

Question 12

Which function would you use to round a number to the nearest integer?

Accepted Answer

ROUND()

Answer

ROUNDDOWN()

Answer

INT()

Answer

ROUNDUP()

Question 13

Which DAX function returns the number of rows in a table?

Accepted Answer

COUNTROWS()

Answer

SUMMARIZECOUNT()

Answer

COUNT()

Answer

ROWCOUNT()

Question 14

What is the purpose of the IF function in DAX?

Accepted Answer

Performs a logical test and returns one value for TRUE result and another for FALSE result

Answer

Filters data

Answer

Creates relationships

Answer

Calculates values based on conditions

Question 15

How can you check if a column contains a specific value?

Accepted Answer

CONTAINS()

Answer

LOOKUP()

Answer

SEARCH()

Answer

MATCH()

Question 16

Which function would you use to replace a value in a column?

Accepted Answer

SUBSTITUTE()

Answer

REPLACE()

Answer

CONVERT()

Answer

UPDATE()

Question 17

What does the FILTER function do?

Accepted Answer

Returns a table that represents a subset of another table

Answer

Aggregates data

Answer

Applies filters to a column

Answer

Sorts data

Question 18

Which function is used to create a table in DAX?

Accepted Answer

DATATABLE()

Answer

NEWTABLE()

Answer

TABLE()

Answer

CREATETABLE()

Question 19

What does the RANKX function do?

Accepted Answer

Returns the ranking of a number in a list of numbers

Answer

Returns the minimum value

Answer

Sorts a column

Answer

Returns the maximum value

Question 20

Which function would you use to format dates in DAX?

Accepted Answer

FORMAT()

Answer

DATEFORMAT()

Answer

STRINGFORMAT()

Answer

DATETOSTRING()

Related quizzes

Related quizzes