1What does the acronym DAX stand for in the context of Power BI?
A.Data Aggregation XML
B.Dynamic Analytical Exchange
C.Data Analysis Expression
D.Database Access Extension
Correct Answer: Data Analysis Expression
Explanation:
DAX stands for Data Analysis Expressions, which is the formula language used in Power BI, Power Pivot in Excel, and Analysis Services.
Incorrect! Try again.
2Which of the following statements best describes a Calculated Column in Power BI?
A.It is calculated on the fly when a report is rendered.
B.It cannot be used in a slicer or filter.
C.It is strictly used for aggregation only.
D.It stores the result of the calculation in the model's memory.
Correct Answer: It stores the result of the calculation in the model's memory.
Explanation:
Calculated columns are computed during data refresh and stored physically in the model, consuming RAM and increasing file size.
Incorrect! Try again.
3When is a DAX Measure calculated?
A.When a new table is imported.
B.At query time, when used in a visual or interaction occurs.
C.When the Power BI file is saved.
D.During data refresh.
Correct Answer: At query time, when used in a visual or interaction occurs.
Explanation:
Measures are dynamic and utilize the CPU to calculate results on the fly based on the current filter context.
Incorrect! Try again.
4What is an 'Implicit Measure'?
A.An aggregation created automatically by dragging a field into a visual.
B.A measure defined using DAX code.
C.A calculated column used as a filter.
D.A measure that uses the CALCULATE function.
Correct Answer: An aggregation created automatically by dragging a field into a visual.
Explanation:
Implicit measures are created by Power BI automatically (like Sum of Sales) when you drag a numeric column to a visual, without writing DAX.
Incorrect! Try again.
5Which symbol is used to start a comment in DAX?
A./*
B.//
C.<!--
D.#
Correct Answer: //
Explanation:
In DAX, a double forward slash (//) or a double dash (--) is used to start a single-line comment.
Incorrect! Try again.
6In DAX syntax, how is a column reference typically formatted?
A.ColumnName[TableName]
B.{TableName}[ColumnName]
C.[TableName].ColumnName
D.'TableName'[ColumnName]
Correct Answer: 'TableName'[ColumnName]
Explanation:
The standard syntax is the table name enclosed in single quotes (if it contains spaces or keywords) followed by the column name in square brackets.
Incorrect! Try again.
7Which function serves as the 'safe' alternative to the division operator (/) to handle divide-by-zero errors?
A.QUOTIENT
B.DIVIDE
C.CALCULATE
D.SAFE.DIV
Correct Answer: DIVIDE
Explanation:
The DIVIDE function (numerator, denominator, [alternate_result]) handles division by zero by returning BLANK or a specified alternate result, avoiding errors.
Incorrect! Try again.
8Which logical function allows you to evaluate multiple conditions and return a result corresponding to the first true condition?
A.OR
B.SWITCH
C.IF
D.COALESCE
Correct Answer: SWITCH
Explanation:
SWITCH is useful for multiple conditions, replacing nested IF statements. It evaluates an expression against a list of values and returns one corresponding result.
Incorrect! Try again.
9What does the DAX function COUNTROWS return?
A.The count of non-blank values in a column.
B.The count of distinct values in a column.
C.The sum of values in a specific column.
D.The count of all rows in a specified table, regardless of content.
Correct Answer: The count of all rows in a specified table, regardless of content.
Explanation:
COUNTROWS simply counts the number of rows in the specified table or table expression.
Incorrect! Try again.
10Which function is used to join two text strings together in DAX?
A.MERGE
B.JOIN
C.CONCATENATE
D.APPEND
Correct Answer: CONCATENATE
Explanation:
CONCATENATE joins two text strings into one text string. The ampersand (&) operator can also be used for this purpose.
Incorrect! Try again.
11What is the primary purpose of the CALCULATE function?
A.To create a calculated table.
B.To perform arithmetic calculations like addition and subtraction.
C.To evaluate an expression in a modified filter context.
D.To calculate the row-by-row sum of a table.
Correct Answer: To evaluate an expression in a modified filter context.
Explanation:
CALCULATE is the most powerful function in DAX because it allows you to change the context in which a calculation is performed (e.g., overriding filters).
Incorrect! Try again.
12Which function returns a table that represents a subset of another table or expression?
A.DISTINCT
B.VALUES
C.RELATED
D.FILTER
Correct Answer: FILTER
Explanation:
The FILTER function takes a table and an expression, and returns a table containing only the rows where the expression evaluates to TRUE.
Incorrect! Try again.
13The RELATED function works only when...
A.The tables are in the same database.
B.You are using DirectQuery mode.
C.You are creating a measure.
D.There is a relationship between tables.
Correct Answer: There is a relationship between tables.
Explanation:
RELATED requires an active relationship between the current table and the related table to fetch values from the 'one' side to the 'many' side.
Incorrect! Try again.
14Which of the following is an example of an Iterator function?
A.MAX
B.COUNT
C.SUMX
D.SUM
Correct Answer: SUMX
Explanation:
Functions ending in 'X' (like SUMX, AVERAGEX) are iterators. They iterate through a table row by row to evaluate an expression.
Incorrect! Try again.
15What is the result of using the ALL function on a table?
A.It selects all distinct values.
B.It returns all rows in a table, ignoring any filters that might have been applied.
C.It aggregates all columns.
D.It deletes all filters permanently from the model.
Correct Answer: It returns all rows in a table, ignoring any filters that might have been applied.
Explanation:
ALL removes filters from the specified table or column, allowing calculations typically used for percentages of totals.
Incorrect! Try again.
16What function would you use to extract the year from a date column?
A.DATE
B.YEAR
C.GETYEAR
D.CALENDAR
Correct Answer: YEAR
Explanation:
The YEAR function expects a date as an argument and returns the year as a four-digit integer.
Incorrect! Try again.
17Which text function removes all spaces from text except for single spaces between words?
A.SUBSTITUTE
B.TRIM
C.CLEAN
D.REPLACE
Correct Answer: TRIM
Explanation:
TRIM removes leading and trailing spaces and replaces multiple internal spaces with a single space.
Incorrect! Try again.
18Which operator is used for logical OR in DAX?
A.||
B.<>
C.&&
D.==
Correct Answer: ||
Explanation:
The double pipe symbol (||) represents the logical OR operator. The && symbol represents AND.
Incorrect! Try again.
19What is the return type of the TODAY() function?
A.Date and Time
B.Date
C.Integer
D.Text string
Correct Answer: Date
Explanation:
TODAY() returns the current date. Even though the data type is DateTime, the time component is set to 12:00:00 AM.
Incorrect! Try again.
20Which function counts the number of distinct values in a column?
A.DISTINCTCOUNT
B.COUNTROWS
C.COUNTA
D.COUNT
Correct Answer: DISTINCTCOUNT
Explanation:
DISTINCTCOUNT counts the number of unique, non-blank values in a column.
Incorrect! Try again.
21Which of the following is NOT a valid DAX logical function?
A.NOT
B.WHEN
C.AND
D.IF
Correct Answer: WHEN
Explanation:
WHEN is not a DAX function. The primary logical functions are IF, AND, OR, NOT, SWITCH, etc.
Incorrect! Try again.
22To create a measure that calculates Sales only for the 'Red' color products, which formula is correct?
CALCULATE is required to apply the filter (Color='Red') to the aggregation (SUM).
Incorrect! Try again.
23What is the difference between NOW() and TODAY()?
A.NOW is static; TODAY updates on refresh.
B.They are identical.
C.NOW returns Date and Time; TODAY returns only the Date.
D.TODAY returns Date and Time; NOW returns only the Date.
Correct Answer: NOW returns Date and Time; TODAY returns only the Date.
Explanation:
NOW() provides the current date and precise time, whereas TODAY() provides the current date with time zeroed out.
Incorrect! Try again.
24Which function allows you to use an inactive relationship between two tables for a specific calculation?
A.PATH
B.USERELATIONSHIP
C.CROSSFILTER
D.RELATED
Correct Answer: USERELATIONSHIP
Explanation:
USERELATIONSHIP specifies a relationship to be used in a specific calculation (usually inside CALCULATE), activating it temporarily if it is inactive.
Incorrect! Try again.
25What does the BLANK() function return?
A.A null value
B.Zero
C.An empty string
D.An error
Correct Answer: A null value
Explanation:
BLANK() returns a blank (null) value. In DAX, Blank corresponds to NULL in databases.
Incorrect! Try again.
26Which function would you use to calculate the number of days between two dates?
A.DATEADD
B.DAYS360
C.DATEDIFF
D.SUBTRACT
Correct Answer: DATEDIFF
Explanation:
DATEDIFF(Date1, Date2, Interval) calculates the count of interval boundaries (Day, Month, Year, etc.) crossed between two dates.
Incorrect! Try again.
27In the context of DAX, what is 'Row Context'?
A.The relationship between two tables.
B.The set of filters applied to a report visual.
C.The hierarchy of drill-down data.
D.The concept that formulas iterate row by row in calculated columns or iterators.
Correct Answer: The concept that formulas iterate row by row in calculated columns or iterators.
Explanation:
Row context refers to the awareness of the current row being processed. It exists natively in Calculated Columns and Iterator functions.
Incorrect! Try again.
28Which function replaces existing text with new text in a text string?
A.SUBSTITUTE
B.REPLACE
C.CHANGE
D.SWAP
Correct Answer: SUBSTITUTE
Explanation:
SUBSTITUTE replaces specific text in a string (e.g., changing 'Old' to 'New'). REPLACE swaps text based on position and length.
Incorrect! Try again.
29What is the purpose of the DISTINCT function?
A.It counts unique values.
B.It removes duplicate rows from a table expression.
C.It returns a one-column table that contains the distinct values from the specified column.
D.It filters a table for unique keys.
Correct Answer: It returns a one-column table that contains the distinct values from the specified column.
Explanation:
DISTINCT returns a table, not a scalar value, containing unique values from the referenced column.
Incorrect! Try again.
30Which DAX function creates a table with a single column of dates covering a specified range?
A.TODAY
B.DATE
C.CALENDAR
D.YEARFRAC
Correct Answer: CALENDAR
Explanation:
CALENDAR(StartDate, EndDate) generates a table with a single column named 'Date' containing a contiguous set of dates.
Incorrect! Try again.
31When using RELATEDTABLE, what type of result is returned?
A.A count of rows.
B.A single value.
C.A Boolean true/false.
D.A table of values related to the current row.
Correct Answer: A table of values related to the current row.
Explanation:
RELATEDTABLE follows a relationship from the 'one' side to the 'many' side and returns a table containing all matching rows.
Incorrect! Try again.
32Which function returns the last date in the current context for the specified column of dates?
A.MAX
B.CLOSINGBALANCEMONTH
C.LASTDATE
D.ENDOFYEAR
Correct Answer: LASTDATE
Explanation:
LASTDATE returns the last date in the current filter context for the specified column of dates.
Incorrect! Try again.
33The LEN function is used to:
A.Calculate the length of a time period.
B.Return the number of characters in a text string.
C.Count the number of rows in a table.
D.Measure the file size.
Correct Answer: Return the number of characters in a text string.
Explanation:
LEN stands for Length; it counts the characters in a string, including spaces.
Incorrect! Try again.
34Which operator is used to check if a value is NOT equal to another?
A.~=
B.NOT
C.!=
D.<>
Correct Answer: <>
Explanation:
In DAX, the operator for 'not equal to' is <>.
Incorrect! Try again.
35What is the primary benefit of using variables (VAR) in DAX?
A.They allow you to write SQL queries.
B.They improve readability and performance by calculating a value once and reusing it.
C.They automatically format the output as currency.
D.They create global parameters for the whole report.
Correct Answer: They improve readability and performance by calculating a value once and reusing it.
Explanation:
Variables store the result of an expression so it can be passed into other parts of the measure without recalculating, enhancing performance and readability.
Incorrect! Try again.
36Which function returns the arithmetic mean of all the numbers in a column?
A.SUM
B.MEDIAN
C.AVERAGE
D.MEAN
Correct Answer: AVERAGE
Explanation:
AVERAGE calculates the arithmetic mean of the values in the column.
Incorrect! Try again.
37If you want to handle errors in a calculation specifically, which function is best?
A.IFERROR
B.ISERROR
C.ERROR
D.IF
Correct Answer: IFERROR
Explanation:
IFERROR(value, value_if_error) evaluates an expression and returns a specified value if the expression returns an error; otherwise, it returns the value of the expression.
Incorrect! Try again.
38Which function moves the given set of dates by a specified interval?
A.DATESINPERIOD
B.DATEADD
C.SAMEPERIODLASTYEAR
D.PARALLELPERIOD
Correct Answer: DATEADD
Explanation:
DATEADD(dates, number_of_intervals, interval) shifts a set of dates forward or backward by the specified number of intervals.
Incorrect! Try again.
39How does the ALLSELECTED function differ from ALL?
A.ALLSELECTED removes filters from rows and columns but preserves filters from slicers/visuals outside the current visual.
B.ALLSELECTED removes absolutely all filters including slicers.
C.There is no difference.
D.ALLSELECTED only works on selected text.
Correct Answer: ALLSELECTED removes filters from rows and columns but preserves filters from slicers/visuals outside the current visual.
Explanation:
ALLSELECTED creates a context that represents all rows and columns in the query, keeping explicit filters and contexts other than row and column filters. Useful for 'visual totals'.
Incorrect! Try again.
40Which text function extracts characters from the middle of a text string?
A.MIDDLE
B.MID
C.SUBSTR
D.CENTER
Correct Answer: MID
Explanation:
MID(text, start_num, num_chars) returns a specific number of characters from a text string, starting at the position you specify.
Incorrect! Try again.
41What is the output of the DAX expression: 5 + BLANK()?
A.Error
B.5
C.BLANK
D.0
Correct Answer: 5
Explanation:
In arithmetic operations (addition/subtraction), DAX treats BLANK as 0. So 5 + 0 = 5.
Incorrect! Try again.
42Which function is used to calculate values over a set of dates that corresponds to the same period in the previous year?
A.PREVIOUSYEAR
B.DATESYTD
C.SAMEPERIODLASTYEAR
D.DATEADD
Correct Answer: SAMEPERIODLASTYEAR
Explanation:
SAMEPERIODLASTYEAR returns a set of dates from the current selection shifted back one year.
Incorrect! Try again.
43In a measure formula, what is the role of the RETURN keyword?
A.It is used to loop through rows.
B.It returns the user to the report view.
C.It restarts the calculation.
D.It outputs the result when using variables (VAR).
Correct Answer: It outputs the result when using variables (VAR).
Explanation:
When using VAR to define variables, the formula must end with RETURN followed by the final expression to output.
Incorrect! Try again.
44Which function evaluates a logical test and returns one value if TRUE and another if FALSE?
A.EVALUATE
B.TRUE
C.IF
D.SWITCH
Correct Answer: IF
Explanation:
The IF function structure is IF(logical_test, value_if_true, value_if_false).
Incorrect! Try again.
45What function is used to aggregate data based on a parent-child hierarchy in DAX?
A.PATHITEM
B.PATH
C.PATHLENGTH
D.All of the above
Correct Answer: All of the above
Explanation:
Parent-child hierarchies are flattened using PATH, PATHLENGTH, and PATHITEM functions to handle navigation through the hierarchy.
Incorrect! Try again.
46Which function returns the standard deviation of a sample population?
A.STDEV.S
B.STDEV.P
C.AVERAGE
D.VAR.S
Correct Answer: STDEV.S
Explanation:
STDEV.S estimates standard deviation based on a sample. STDEV.P is for the entire population.
Incorrect! Try again.
47What is the purpose of the VALUES function?
A.To return a one-column table of unique values from a column, respecting the current filter context.
B.To convert text to numbers.
C.To return a list of all measures.
D.To sum up values.
Correct Answer: To return a one-column table of unique values from a column, respecting the current filter context.
Explanation:
Unlike DISTINCT, VALUES respects the current filter context and can also return a 'Blank' row if invalid relationships exist.
Incorrect! Try again.
48Which iterator function would you use to find the highest value of an expression evaluated for every row in a table?
A.MAXX
B.MAX
C.SUMX
D.HIGHEST
Correct Answer: MAXX
Explanation:
MAXX iterates over a table, evaluates an expression for each row, and returns the largest resulting value.
Incorrect! Try again.
49Which date function returns the number of the week in the year (1-54)?
A.DAY
B.WEEKDAY
C.WEEKNUM
D.WEEK
Correct Answer: WEEKNUM
Explanation:
WEEKNUM(date, [return_type]) returns the week number of the year.
Incorrect! Try again.
50What is Filter Context?
A.The set of filters applied to the data model by slicers, visuals, and report filters at the moment of calculation.
B.The relationship between tables.
C.The context applied by the row currently being iterated.
D.The syntax checking of the formula.
Correct Answer: The set of filters applied to the data model by slicers, visuals, and report filters at the moment of calculation.
Explanation:
Filter context describes the active set of filters (from user interaction or DAX functions) that restricts the data before a calculation takes place.