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
- Which tool commonly uses DAX for data modeling and analysis?
A) Microsoft Word
B) Microsoft Excel
C) Microsoft PowerPoint
D) Microsoft Access
View Answer
- 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
- Which of the following is NOT a DAX function category?
A) Date and Time
B) Statistical
C) Text
D) Networking
View Answer
- 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
- 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
- Which DAX function is used to retrieve a single value from a related table?
A) RELATED
B) LOOKUPVALUE
C) RELATEDTABLE
D) ALLRELATED
View Answer
- 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
- 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
- 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
- What is the DAX function used to find the earliest date in a column?
A) MIN
B) FIRSTDATE
C) EARLIEST
D) STARTDATE
View Answer
- 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
- 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
- Which DAX function is used to iterate through a table?
A) ROW
B) FOR
C) ITERATE
D) SUMX
View Answer
- 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
- Which DAX function is used to calculate the median of a column?
A) MEDIAN
B) CALCULATE
C) AVERAGE
D) PERCENTILEX
View Answer
- 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
- Which DAX function is used to find the last date in a column?
A) MAX
B) LASTDATE
C) LATEST
D) ENDDATE
View Answer
- 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
- Which DAX function is used to calculate the difference between two dates?
A) DATEDIFF
B) TIMEDIFF
C) DIFFDATE
D) DATESUBTRACT
View Answer
- 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
- Which DAX function is used to calculate the difference between two numeric values?
A) SUBTRACT
B) DIFFERENCE
C) ABS
D) MINUS
View Answer
- 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
- Which DAX function is used to calculate the standard deviation of a column?
A) VARIANCE
B) STDDEV
C) STDEV
D) STDEV.P
View Answer
- 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
Test your skills : Quizz
