Identifiers

All the identifiers available in Inforiver are showcased with examples in the below .pbix file.

IDENTIFIERUSAGEDESCRIPTION

Calculated measure formula

Returns a reference to a specific column in the report

Calculated row formula

Returns all the children's values (till the leaf level) as an array

Calculated row/column formula

Returns the position of a column

Calculated column formula

Checks if the specified value is part of the list

Calculated column formula

Checks if all the specified values are part of the list

Calculated column formula

Checks if one or more of the specified values are part of the list

Calculated column formula

Returns the row level in the hierarchy

Calculated column formula

Checks whether the specified value is an exact match

Calculated row formula

Returns all the immediate children's values as an array

Calculated column formula

Changes the absolute cell/column reference to a relative reference

Calculated row formula

Returns the value of the column relative to the current column

ROW.LABEL

Calculated row formula

Returns field values used to populate rows in the report

Calculated row formula

Returns a reference to the parent levels in the hierarchy

Last updated