Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data Analysis Expressions

Total questions: 10

Worksheet time: 2mins

Name
Class
Date
1.

It is a library of functions and operators that can be combined to build formulas and expressions used by Microsoft BI Tools.

a)

Data Analysis Expressions

b)

Azure Analysis Services

c)

Power BI

d)

Pivot for Excel

2.

The following are the types of calculations that can be added in a data model using DAX, EXCEPT:

a)

Calculated Columns

b)

Measures

c)

Calculated Tables

d)

Calculated Graphs

3.

It is best to use calculated columns when dealing with huge amount of data.

a)

True

b)

False

4.

Which of the following functions should be used if you want to convert a value to text?

a)

CONCATENATE

b)

SWITCH

c)

FORMAT

d)

EXACT

5.

Which of the following functions should be used if you want to evaluate an expression against a list of values and returns one of multiple possible result expressions?

a)

SWITCH

b)

CONCATENATE

c)

IF

d)

RELATED

6.

This function returns the sum of an expression evaluated for each row in a table.

a)

SUM

b)

SUMX

c)

AVERAGE

d)

AVERAGEX

7.

This function returns the count of interval boundaries crossed between two dates.

a)

EOMONTH

b)

DATESBETWEEN

c)

DATEDIFF

d)

DATESINPERIOD

8.

This function returns a related value from another table.

a)

RELATED

b)

RELATEDTABLE

c)

CONCATENATE

d)

SWITCH

9.

Which of the following functions should you used if you want to know the total number of unique customers who bought from your store?

a)

COUNT

b)

DISTINCTCOUNT

c)

MAXX

d)

SUMX

10.

This function returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date.

a)

DATES IN PERIOD

b)

DATESBETWEEN

c)

ENDOFMONTH

d)

TOTALYTD