DAX Text Functions MCQS

Q. Which DAX function joins two text values into one string?

A

CONCATENATE()

B

SUM()

C

IF()

D

RANKX()

Solution:

CONCATENATE() combines two text values into a single string.

Q. What does UPPER() do in DAX?

A

Converts text to uppercase

B

Rounds a number up

C

Returns the highest value in a column

D

Removes duplicate text

Solution:

UPPER() converts a text string to all uppercase letters.

Q. What does FORMAT() primarily do?

A

Deletes blank rows

B

Converts a number or date into text using a specified pattern

C

Creates a relationship between tables

D

Sorts a column

Solution:

FORMAT() turns a raw number or date value into a display-ready text string based on a format pattern.

Q. Besides CONCATENATE(), what else can join two text columns in DAX?

A

The & operator

B

The + operator

C

The = operator

D

The % operator

Solution:

The & operator joins text values the same way CONCATENATE() does, and is often used for more than two values at once.

Q. What would FORMAT([Total Sales], "$#,##0") produce for a value of 12500?

A

12500

B

$12,500

C

12,500.00

D

$12500.00

Solution:

The pattern formats the number as a dollar amount with a thousands separator and no decimals.

Q. Why might a report builder prefer FORMAT() over simply setting number formatting in the visual's format pane?

A

FORMAT() lets you build a custom text label combining a formatted number with other text, which visual-level formatting alone can't do

B

FORMAT() is required for all measures

C

Visual-level formatting doesn't work on cards

D

FORMAT() is faster in every case

Solution:

FORMAT() is useful specifically when you need to combine a formatted number with surrounding text in a single string, something the visual’s built-in number formatting can’t do.

Q. LEFT() is returning unexpected characters from a text column. What's a common cause?

A

Leading or trailing spaces in the source data are being counted as characters

B

LEFT() only works on numbers

C

The column has too many rows

D

DAX text functions require a relationship

Solution:

LEFT() counts every character including spaces, so untrimmed source data can produce unexpected results.

DAX Text Functions MCQS

Q. Which DAX function joins two text values into one string?

Solution:

Q. What does UPPER() do in DAX?

Solution:

Q. What does FORMAT() primarily do?

Solution:

Q. Besides CONCATENATE(), what else can join two text columns in DAX?

Solution:

Q. What would FORMAT([Total Sales], "$#,##0") produce for a value of 12500?

Solution:

Q. Why might a report builder prefer FORMAT() over simply setting number formatting in the visual's format pane?

Solution:

Q. LEFT() is returning unexpected characters from a text column. What's a common cause?

Solution:

Related Questions

Q. DAX Variables MCQS

Q. DAX CALCULATE Function MCQS

Q. DAX Logical Functions MCQS

Get Question Bank