Power BI DAX Multiple-Choice Questions (MCQ) and Answers

DAX (Data Analysis Expressions) is a powerful formula language used in Microsoft Power BI, Excel, and other data analytics tools. This set of multiple-choice questions will test your understanding of key concepts and functions in DAX.

### Power BI DAX MCQ and Answers

- What does DAX stand for?

A) Data Access Expressions

B) Data Analysis Extensions

C) Data Analysis Expressions

D) Dynamic Analysis XML

**View Answer**

**C) Data Analysis Expressions**

- Which tool commonly uses DAX for data modeling and analysis?

A) Microsoft Word

B) Microsoft Excel

C) Microsoft PowerPoint

D) Microsoft Access

** View Answer**

**B) Microsoft Excel**- What is a primary purpose of using DAX?

A) Creating visualizations

B) Writing SQL queries

C) Calculating formulas for data analysis

D) Building machine learning models

** View Answer**

**C) Calculating formulas for data analysis**

- Which of the following is NOT a DAX function category?

A) Date and Time

B) Statistical

C) Text

D) Networking

** View Answer**

**D) Networking**

- In DAX, what function is used to return the total number of rows in a table?

A) COUNT

B) ROWCOUNT

C) TOTALROWS

D) ROWCOUNTX

** View Answer**

**C) TOTALROWS**

- What does the CALCULATE function do in DAX?

A) Calculates an expression in a modified filter context

B) Calculates the average of a column

C) Returns the maximum value in a column

D) Counts the distinct values in a column

** View Answer**

**A) Calculates an expression in a modified filter context**

- Which DAX function is used to retrieve a single value from a related table?

A) RELATED

B) LOOKUPVALUE

C) RELATEDTABLE

D) ALLRELATED

** View Answer**

**B) LOOKUPVALUE**

- What is the purpose of the DAX function SUMX?

A) Returns the sum of an expression evaluated for each row in a table

B) Returns the sum of a column

C) Returns the sum of distinct values in a column

D) Returns the sum of values based on a condition

** View Answer**

**A) Returns the sum of an expression evaluated for each row in a table**

- What is a filter context in DAX?

A) A visual representation of data

B) A defined set of conditions applied to data calculations

C) An error message generated by invalid DAX syntax

D) A type of table relationship** **

** View Answer**

**B) A defined set of conditions applied to data calculations**

- Which DAX function is used to add a new column to a table based on a calculation?

A) ADDCOLUMN

B) CALCULATETABLE

C) SUMMARIZE

D) FILTER

**View Answer**

**A) ADDCOLUMN**

- What is the DAX function used to find the earliest date in a column?

A) MIN

B) FIRSTDATE

C) EARLIEST

D) STARTDATE

** View Answer**

**B) FIRSTDATE**

- Which DAX function is used to calculate the year-to-date total for a measure?

A) TOTALYTD

B) YTD

C) YEARSTOTAL

D) CUMULATIVE

** View Answer**

**A) TOTALYTD**

- In DAX, how do you reference a column from a table?

A) Using table[column]

B) Using column.table

C) Using COLUMN(table, “column”)

D) Using GETCOLUMN(table, “column”)

** View Answer**

**A) Using table[column]**

- Which DAX function is used to iterate through a table?

A) ROW

B) FOR

C) ITERATE

D) SUMX

** View Answer**

**D) SUMX**

- What does the RELATEDTABLE function do in DAX?

A) Returns a table that is related to the current table

B) Returns a table filtered by related values

C) Returns a table based on a related column

D) Returns a table with all related rows

** View Answer**

**D) Returns a table with all related rows**

- Which DAX function is used to calculate the median of a column?

A) MEDIAN

B) CALCULATE

C) AVERAGE

D) PERCENTILEX

** View Answer**

**A) MEDIAN**

- What is the purpose of the RELATED function in DAX?

A) To establish a relationship between tables

B) To calculate values based on related rows

C) To retrieve a single related value

D) To filter a table by related columns

** View Answer**

**e**

**C) To retrieve a single related valu**

- Which DAX function is used to find the last date in a column?

A) MAX

B) LASTDATE

C) LATEST

D) ENDDATE

** View Answer**

**B) LASTDATE**

- What does the BLANK function do in DAX?

A) Removes blank rows from a table

B) Replaces errors with blank values

C) Returns a blank value

D) Fills blank cells with a specified value

** View Answer**

**C) Returns a blank value**

- Which DAX function is used to calculate the difference between two dates?

A) DATEDIFF

B) TIMEDIFF

C) DIFFDATE

D) DATESUBTRACT

** View Answer**

**A) DATEDIFF**

- What is the purpose of the ALL function in DAX?

A) Returns all distinct values in a column

B) Removes filters from a column

C) Calculates all values in a column

D) Returns all rows in a table

** View Answer**

**B) Removes filters from a column**

- Which DAX function is used to calculate the difference between two numeric values?

A) SUBTRACT

B) DIFFERENCE

C) ABS

D) MINUS

** View Answer**

**A) SUBTRACT**

- What does the RANKX function do in DAX?

A) Calculates the rank of values in a column

B) Returns the value with the highest rank

C) Filters data based on ranks

D) Finds the next value in a rank

** View Answer**

**A) Calculates the rank of values in a column**

- Which DAX function is used to calculate the standard deviation of a column?

A) VARIANCE

B) STDDEV

C) STDEV

D) STDEV.P

** View Answer**

**D) STDEV.P**

- What is the purpose of the FIRSTNONBLANK function in DAX?

A) Returns the first non-blank value in a column

B) Filters a table to show only non-blank rows

C) Returns the earliest non-blank date

D) Identifies the first non-blank cell in a table

** View Answer**

**A) Returns the first non-blank value in a column**

** **