LASTNONBLANK

The LASTNONBLANK function in Infoveave retrieves the first non-blank (non-empty) value within a specified dataset or column, filtered by the current context.

Applicable to

• Calculated Columns
• Expressions

Return Value

The last non-blank value encountered within the dataset or column.

Remark

• Useful for identifying and extracting the first meaningful data from a list or dataset.
• Can be used across Dates, Strings, and Numbers.

Syntax

LASTNONBLANK(<expression>)

LASTNONBLANK in Board Expression

Note

Expressions add visual effects to your dashboard through widget-specific conditions. They are not for managing or modifying data.

Parameter	Description
Expression	A placeholder in a function that is replaced with the actual widget and measure names.
Widget Name	The specific name or identifier of the widget used for data visualization in the Infoboard.
Measure	The name of the measure displayed or analyzed using the widget.

Steps to Use LASTNONBLANK

1. Write the LASTNONBLANK function. For instance LASTNONBLANK(<expression>)
2. Replace <expression> with 'Widget Name'[Measure].Replace Widget Name with your widget’s name and Measure with the corresponding measure name.
3. To learn how to configure an Expression in Infoveave, visit the Configure Expression section.

LASTNONBLANK in Calculated Columns

Parameter	Description
Expression	A placeholder in a function that is replaced with the column names.
Column Name	The name of the column in the dataset or Datasource containing the values you want to analyze.

Steps to Use LASTNONBLANK in Calculated Columns

1. Write the LASTNONBLANK function. For instance LASTNONBLANK(<expression>)
2. Replace <expression> with [Column Name].Replace Column Name with your required column name.
3. To learn how to add calculated columns in Infoveave, visit the Calculated Columns section.