Information Functions

Question 1

ISONORAFTER(scalar_expression, scalar_expression[, sort_order [, scalar_expression, scalar_expression[, sort_order]]…)

Answer 1

A boolean function that emulates the behavior of a Start At clause and returns true for a row that meets all of the condition parameters.

Question 2

ISAFTER(scalar_expression, scalar_expression[, sort_order [, scalar_expression, scalar_expression[, sort_order]]…)

Answer 2

A boolean function that emulates the behavior of a ‘Start At’ clause and returns true for a row that meets all of the condition parameters.

Question 3

ISEMPTY(table_expression)

Answer 3

Checks if a table is empty.

Question 4

ISNONTEXT(value)

Answer 4

Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.

Question 5

ISTEXT(value)

Answer 5

Checks if a value is text, and returns TRUE or FALSE.

Question 6

ISLOGICAL(value)

Answer 6

Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.

Question 7

ISNUMBER(value)

Answer 7

Checks whether a value is a number, and returns TRUE or FALSE.

Question 8

ISERROR(value)

Answer 8

Checks whether a value is an error, and returns TRUE or FALSE.

Question 9

ISBLANK(value)

Answer 9

Checks whether a value is blank, and returns TRUE or FALSE.

Question 10

ISSUBTOTAL(columnName)

Answer 10

Creates another column in a SUMMARIZE expression that returns True if the row contains subtotal values for the column given as argument, otherwise returns False.

Question 11

NONVISUAL(expression)

Answer 11

Marks a value filter in a SUMMARIZECOLUMNS expression as non-visual. This function can only be used within a SUMMARIZECOLUMNS expression.

Question 12

COLUMNSTATISTICS ()

Answer 12

Returns a table of statistics regarding every column in every table in the model.

Question 13

CUSTOMDATA()

Answer 13

Returns the content of the CustomData property in the connection string.

Question 14

USEROBJECTID()

Answer 14

Returns the current user’s Object ID from Azure AD or security identifier (SID).

Question 15

USERNAME()

Answer 15

Returns the domain name and username from the credentials given to the system at connection time.

Question 16

USERCULTURE()

Answer 16

Returns the locale (language code-country code) for the current user, determined by the operating system, browser settings, or Power BI service.

Question 17

USERPRINCIPALNAME()

Answer 17

Returns the user principal name.

Question 18

ISEVEN(number)

Answer 18

Returns TRUE if number is even, or FALSE if number is odd.

Question 19

ISODD(number)

Answer 19

Returns TRUE if number is odd, or FALSE if number is even.

Question 20

CONTAINSROW(Table, Value [, Value [, …] ] )

Answer 20

Returns TRUE if there exists at least one row where all columns have specified values.

Question 21

CONTAINS(table, columnName, value[, columnName, value]…)

Answer 21

Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false.

Question 22

CONTAINSSTRING(within_text, find_text)

Answer 22

Returns TRUE or FALSE indicating whether one string contains another string.

Question 23

CONTAINSSTRINGEXACT(within_text, find_text)

Answer 23

Returns TRUE or FALSE indicating whether one string contains another string.

Question 24

HASONEVALUE(columnName)

Answer 24

Returns TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE.

Question 25

HASONEFILTER(columnName)

Answer 25

Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.

Question 26

ISINSCOPE(columnName)

Answer 26

Returns true when the specified column is the level in a hierarchy of levels.

Question 27

ISFILTERED(TableNameOrColumnName)

Answer 27

Returns TRUE when the specified table or column is being filtered directly.

Question 28

ISCROSSFILTERED(TableNameOrColumnName)

Answer 28

Returns TRUE when the specified table or column is cross-filtered.

Question 29

SELECTEDMEASURENAME()

Answer 29

Used by expressions for calculation items to determine the measure that is in context by name.

Question 30

ISSELECTEDMEASURE( M1, M2, … )

Answer 30

Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.

Question 31

SELECTEDMEASURE()

Answer 31

Used by expressions for calculation items to reference the measure that is in context.

Question 32

SELECTEDMEASUREFORMATSTRING()

Answer 32

Used by expressions for calculation items to retrieve the format string of the measure that is in context.