Back to Subject

Unit 4: Advanced Calculations with DAX - Practice Quiz

INT374 — Data Analytics With Power Bi 50 Questions
0 Correct 0 Wrong 50 Left
0/50

1 What does the acronym DAX stand for in the context of Power BI?

A. Dynamic Analytical Exchange
B. Data Analysis Expression
C. Data Aggregation XML
D. Database Access Extension

2 Which of the following statements best describes a Calculated Column in Power BI?

A. It is strictly used for aggregation only.
B. It stores the result of the calculation in the model's memory.
C. It cannot be used in a slicer or filter.
D. It is calculated on the fly when a report is rendered.

3 When is a DAX Measure calculated?

A. At query time, when used in a visual or interaction occurs.
B. When a new table is imported.
C. During data refresh.
D. When the Power BI file is saved.

4 What is an 'Implicit Measure'?

A. A measure that uses the CALCULATE function.
B. A measure defined using DAX code.
C. A calculated column used as a filter.
D. An aggregation created automatically by dragging a field into a visual.

5 Which symbol is used to start a comment in DAX?

A. <!--
B. //
C. /*
D. #

6 In DAX syntax, how is a column reference typically formatted?

A. {TableName}[ColumnName]
B. [TableName].ColumnName
C. 'TableName'[ColumnName]
D. ColumnName[TableName]

7 Which function serves as the 'safe' alternative to the division operator (/) to handle divide-by-zero errors?

A. CALCULATE
B. SAFE.DIV
C. QUOTIENT
D. DIVIDE

8 Which logical function allows you to evaluate multiple conditions and return a result corresponding to the first true condition?

A. COALESCE
B. SWITCH
C. OR
D. IF

9 What does the DAX function COUNTROWS return?

A. The count of distinct values in a column.
B. The count of all rows in a specified table, regardless of content.
C. The sum of values in a specific column.
D. The count of non-blank values in a column.

10 Which function is used to join two text strings together in DAX?

A. APPEND
B. JOIN
C. MERGE
D. CONCATENATE

11 What is the primary purpose of the CALCULATE function?

A. To create a calculated table.
B. To evaluate an expression in a modified filter context.
C. To calculate the row-by-row sum of a table.
D. To perform arithmetic calculations like addition and subtraction.

12 Which function returns a table that represents a subset of another table or expression?

A. RELATED
B. VALUES
C. DISTINCT
D. FILTER

13 The RELATED function works only when...

A. You are using DirectQuery mode.
B. You are creating a measure.
C. The tables are in the same database.
D. There is a relationship between tables.

14 Which of the following is an example of an Iterator function?

A. SUMX
B. COUNT
C. MAX
D. SUM

15 What is the result of using the ALL function on a table?

A. It deletes all filters permanently from the model.
B. It aggregates all columns.
C. It selects all distinct values.
D. It returns all rows in a table, ignoring any filters that might have been applied.

16 What function would you use to extract the year from a date column?

A. GETYEAR
B. CALENDAR
C. YEAR
D. DATE

17 Which text function removes all spaces from text except for single spaces between words?

A. REPLACE
B. CLEAN
C. SUBSTITUTE
D. TRIM

18 Which operator is used for logical OR in DAX?

A. ==
B. ||
C. &&
D. <>

19 What is the return type of the TODAY() function?

A. Date
B. Integer
C. Text string
D. Date and Time

20 Which function counts the number of distinct values in a column?

A. COUNTROWS
B. DISTINCTCOUNT
C. COUNT
D. COUNTA

21 Which of the following is NOT a valid DAX logical function?

A. IF
B. WHEN
C. AND
D. NOT

22 To create a measure that calculates Sales only for the 'Red' color products, which formula is correct?

A. SUM(Sales[Amount]) WHERE Product[Color] = 'Red'
B. CALCULATE(SUM(Sales[Amount]), Product[Color] = 'Red')
C. IF(Product[Color] = 'Red', SUM(Sales[Amount]))
D. FILTER(Sales, Product[Color] = 'Red')

23 What is the difference between NOW() and TODAY()?

A. They are identical.
B. NOW is static; TODAY updates on refresh.
C. TODAY returns Date and Time; NOW returns only the Date.
D. NOW returns Date and Time; TODAY returns only the Date.

24 Which function allows you to use an inactive relationship between two tables for a specific calculation?

A. PATH
B. USERELATIONSHIP
C. RELATED
D. CROSSFILTER

25 What does the BLANK() function return?

A. An empty string
B. An error
C. A null value
D. Zero

26 Which function would you use to calculate the number of days between two dates?

A. DATEDIFF
B. DATEADD
C. DAYS360
D. SUBTRACT

27 In the context of DAX, what is 'Row Context'?

A. The concept that formulas iterate row by row in calculated columns or iterators.
B. The set of filters applied to a report visual.
C. The relationship between two tables.
D. The hierarchy of drill-down data.

28 Which function replaces existing text with new text in a text string?

A. SUBSTITUTE
B. CHANGE
C. REPLACE
D. SWAP

29 What is the purpose of the DISTINCT function?

A. It returns a one-column table that contains the distinct values from the specified column.
B. It filters a table for unique keys.
C. It counts unique values.
D. It removes duplicate rows from a table expression.

30 Which DAX function creates a table with a single column of dates covering a specified range?

A. YEARFRAC
B. DATE
C. CALENDAR
D. TODAY

31 When using RELATEDTABLE, what type of result is returned?

A. A count of rows.
B. A Boolean true/false.
C. A table of values related to the current row.
D. A single value.

32 Which function returns the last date in the current context for the specified column of dates?

A. LASTDATE
B. CLOSINGBALANCEMONTH
C. ENDOFYEAR
D. MAX

33 The LEN function is used to:

A. Calculate the length of a time period.
B. Measure the file size.
C. Return the number of characters in a text string.
D. Count the number of rows in a table.

34 Which operator is used to check if a value is NOT equal to another?

A. NOT
B. !=
C. <>
D. ~=

35 What is the primary benefit of using variables (VAR) in DAX?

A. They automatically format the output as currency.
B. They improve readability and performance by calculating a value once and reusing it.
C. They allow you to write SQL queries.
D. They create global parameters for the whole report.

36 Which function returns the arithmetic mean of all the numbers in a column?

A. MEAN
B. SUM
C. AVERAGE
D. MEDIAN

37 If you want to handle errors in a calculation specifically, which function is best?

A. ERROR
B. ISERROR
C. IF
D. IFERROR

38 Which function moves the given set of dates by a specified interval?

A. PARALLELPERIOD
B. DATESINPERIOD
C. SAMEPERIODLASTYEAR
D. DATEADD

39 How 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. There is no difference.
C. ALLSELECTED only works on selected text.
D. ALLSELECTED removes absolutely all filters including slicers.

40 Which text function extracts characters from the middle of a text string?

A. MIDDLE
B. SUBSTR
C. MID
D. CENTER

41 What is the output of the DAX expression: 5 + BLANK()?

A. 5
B. Error
C. 0
D. BLANK

42 Which function is used to calculate values over a set of dates that corresponds to the same period in the previous year?

A. DATEADD
B. DATESYTD
C. SAMEPERIODLASTYEAR
D. PREVIOUSYEAR

43 In a measure formula, what is the role of the RETURN keyword?

A. It is used to loop through rows.
B. It outputs the result when using variables (VAR).
C. It returns the user to the report view.
D. It restarts the calculation.

44 Which function evaluates a logical test and returns one value if TRUE and another if FALSE?

A. IF
B. TRUE
C. SWITCH
D. EVALUATE

45 What function is used to aggregate data based on a parent-child hierarchy in DAX?

A. PATHLENGTH
B. All of the above
C. PATH
D. PATHITEM

46 Which function returns the standard deviation of a sample population?

A. STDEV.S
B. STDEV.P
C. VAR.S
D. AVERAGE

47 What is the purpose of the VALUES function?

A. To convert text to numbers.
B. To sum up values.
C. To return a list of all measures.
D. To return a one-column table of unique values from a column, respecting the current filter context.

48 Which iterator function would you use to find the highest value of an expression evaluated for every row in a table?

A. MAX
B. SUMX
C. HIGHEST
D. MAXX

49 Which date function returns the number of the week in the year (1-54)?

A. WEEKDAY
B. WEEK
C. DAY
D. WEEKNUM

50 What is Filter Context?

A. The syntax checking of the formula.
B. The relationship between tables.
C. The set of filters applied to the data model by slicers, visuals, and report filters at the moment of calculation.
D. The context applied by the row currently being iterated.
Previous MCQ
Unit 3
Next MCQ
Unit 5