---
title: LASTNONBLANKX
description: Use the LASTNONBLANKX function to retrieve the last non-blank value in a dataset based on specific conditions, ideal for responsive monitoring and data analysis.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# LASTNONBLANKX

The LASTNONBLANKX function in Infoveave identifies the last non-blank (non-empty) value in a dataset or column that meets a specific condition, filtered by the current context.

## Applicable to

* Calculated Columns
* Expressions

## Return Value

The first non-blank value in the dataset or column that meets the specified condition.

## Remark

LASTNONBLANKX extracts the initial non-empty data point within datasets, considering a condition. It's valuable for responsive monitoring and alerting applications, providing selective and context-aware results.

## Syntax

```
LASTNONBLANKX(<expression>,<condition>)
```

## LASTNONBLANKX in Board Expression

<Aside>
Expressions add visual effects to your dashboard through widget-specific conditions. They don't manage or modify data.
</Aside>

| Parameter      | Description                                                                                                    |
|----------------|----------------------------------------------------------------------------------------------------------------|
| Expression     | A placeholder replaced with actual widget and measure names.                                                    |
| Condition      | A placeholder replaced with the condition filter.                                                              |
| 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.                                               |
| Dimension      | The dimension column displayed or analyzed using the widget.                                                  |
| Dimension Value| The specific dimension items within the dimension column used for visualization in the widget.                   |

Steps to Use LASTNONBLANKX

<Steps>
1. Write the LASTNONBLANKX function. For instance `LASTNONBLANKX(<expression>,<condition>)`
2. Where `expression` equals `'Widget Name'[Measure]` and `condition` equals `[Dimension Name]="Dimension Value"`.Replace **Widget Name** with your widget's name, **Measure** with the required measure name, **Dimension** with the required dimension name, and **Dimension Value** with the dimension value of the selected dimension name.
3. To learn how to configure an Expression in Infoveave, visit the [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions) section.
</Steps>

## LASTNONBLANKX in Calculated Columns

| Parameter        | Description                                                                                           |
|------------------|-------------------------------------------------------------------------------------------------------|
| Expression       | A placeholder replaced with column names.                                                              |
| Condition        | A placeholder replaced with the condition filter.                                                       |
| Column Name      | The name of the column in the dataset or Datasource containing the values you want to analyze.         |
| Filter Condition | A filter condition returning data points meeting the defined condition you want to analyze. Can be string or numeric. |

Steps to Use LASTNONBLANKX in Calculated Columns

<Steps>
1. Write the LASTNONBLANKX function. For instance `LASTNONBLANKX(<expression>,<condition>)`
2. Replace `<expression>` with the required `[Column Name]` and `<condition>` equals `[Column Name]="Filter Condition"`
3. Replace **Column Name** with your column's name and **Filter Condition** with the required condition.
4. To learn how to add calculated columns in Infoveave, visit the [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/) section.
</Steps>

<Aside type="caution">
Do not use double quotes when setting up a numeric as the filter condition.
</Aside>