Question 1

What is the primary use of DAX in Power BI?

Accepted Answer

To create custom calculations

Answer

To design report layouts

Answer

To configure security settings

Answer

To manage data connections

Question 2

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

Accepted Answer

TOTALYTD

Answer

TOTALYEAR

Answer

YEARLYTOTAL

Answer

CUMULATIVETOTAL

Question 3

How do you create a calculated column in Power BI using DAX?

Accepted Answer

By using the 'New Column' option

Answer

By using the 'New Report' option

Answer

By using the 'New Table' option

Answer

By using the 'New Measure' option

Question 4

What does the CALCULATE function in DAX do?

Accepted Answer

Modifies the filter context

Answer

Creates a new column

Answer

Sorts data in ascending order

Answer

Joins two tables

Question 5

Which DAX function would you use to return the first date of the month in a column of dates?

Accepted Answer

STARTOFMONTH

Answer

BEGINNINGOFMONTH

Answer

MONTHSTART

Answer

FIRSTDATE

Question 6

Which function in DAX is used to return a table with all columns and rows from a specified table, but with duplicate rows removed?

Accepted Answer

DISTINCT

Answer

SUMMARIZE

Answer

VALUES

Answer

REMOVEFILTERS

Question 7

What is the correct function to use for counting rows that meet a specific condition?

Accepted Answer

COUNTROWS

Answer

COUNT

Answer

SUMX

Answer

COUNTA

Question 8

Which DAX function returns the running total in a column of numbers in a table?

Accepted Answer

RUNNINGTOTAL

Answer

CUMULATIVE

Answer

SUM

Answer

TOTALRUN

Question 9

In DAX, what is the purpose of the RELATED function?

Accepted Answer

To fetch a related value from another table

Answer

To calculate a column's sum

Answer

To create a relationship between tables

Answer

To join two columns in a table

Question 10

Which function would you use to change the context of a calculation in DAX?

Accepted Answer

CALCULATETABLE

Answer

CONTEXTSWITCH

Answer

FILTERCHANGE

Answer

CHANGECONTEXT

Question 11

How do you check for an empty value in DAX?

Accepted Answer

Using the ISBLANK function

Answer

Using the ISNOTHING function

Answer

Using the ISNULL function

Answer

Using the ISEMPTY function

Question 12

Which DAX function is used to concatenate two strings?

Accepted Answer

CONCATENATE

Answer

MERGE

Answer

COMBINE

Answer

JOIN

Question 13

What does the ALL function do in DAX?

Accepted Answer

Removes all filters from a table or column

Answer

Sums all values in a table or column

Answer

Applies all filters to a table or column

Answer

Returns the total row count of a table

Question 14

How do you round a number to the nearest integer in DAX?

Accepted Answer

Using the ROUND function

Answer

Using the FLOOR function

Answer

Using the INT function

Answer

Using the CEILING function

Question 15

What is the purpose of the FILTER function in DAX?

Accepted Answer

To return a table with only the rows that meet a specific condition

Answer

To sort a table by a column

Answer

To change the context of a calculation

Answer

To remove duplicates from a table

Question 16

Which function would you use to calculate the average of a column in DAX?

Accepted Answer

AVERAGE

Answer

MEAN

Answer

SUMX

Answer

MEDIAN

Question 17

How do you create a new table in Power BI using DAX?

Accepted Answer

By using the 'New Table' option

Answer

By using the 'New Column' option

Answer

By using the 'New Measure' option

Answer

By using the 'New Report' option

Question 18

What is the primary function of the SUMMARIZE function in DAX?

Accepted Answer

To create a summary table for the requested totals over a set of groups

Answer

To sum all the values in a column

Answer

To calculate the average of a column

Answer

To return distinct values from a column

Question 19

Which DAX function is used to retrieve the value of a column for the first row in the current context?

Accepted Answer

FIRSTNONBLANK

Answer

FIRSTVALUE

Answer

FIRSTROW

Answer

STARTROW

Question 20

What does the EARLIER function in DAX do?

Accepted Answer

Refers to the earlier row context in a nested row context

Answer

Checks for previous data entry

Answer

Returns the first value in a column

Answer

Calculates the year-to-date value

Related quizzes

Related quizzes