Information Functions Flashcards

1
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ISEMPTY(table_expression)

A

Checks if a table is empty.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ISNONTEXT(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ISTEXT(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ISLOGICAL(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ISNUMBER(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ISERROR(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ISBLANK(value)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

ISSUBTOTAL(columnName)

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

NONVISUAL(expression)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

COLUMNSTATISTICS ()

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

CUSTOMDATA()

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

USEROBJECTID()

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

USERNAME()

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

USERCULTURE()

A

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

17
Q

USERPRINCIPALNAME()

A

Returns the user principal name.

18
Q

ISEVEN(number)

A

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

19
Q

ISODD(number)

A

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

20
Q

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

A

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

21
Q

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

A

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

22
Q

CONTAINSSTRING(within_text, find_text)

A

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

23
Q

CONTAINSSTRINGEXACT(within_text, find_text)

A

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

24
Q

HASONEVALUE(columnName)

A

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

25
HASONEFILTER(columnName)
Returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.
26
ISINSCOPE(columnName)
Returns true when the specified column is the level in a hierarchy of levels.
27
ISFILTERED(TableNameOrColumnName)
Returns TRUE when the specified table or column is being filtered directly.
28
ISCROSSFILTERED(TableNameOrColumnName)
Returns TRUE when the specified table or column is cross-filtered.
29
SELECTEDMEASURENAME()
Used by expressions for calculation items to determine the measure that is in context by name.
30
ISSELECTEDMEASURE( M1, M2, ... )
Used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.
31
SELECTEDMEASURE()
Used by expressions for calculation items to reference the measure that is in context.
32
SELECTEDMEASUREFORMATSTRING()
Used by expressions for calculation items to retrieve the format string of the measure that is in context.