---
title: LASTNONBLANK
description: Learn how to use the LASTNONBLANK function to retrieve the last non-empty value from datasets, enhancing your data analysis with powerful filtering and visualization techniques.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# 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

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

| 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

<Steps>
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](/insights-v8/advanced-configuration/#configuring-expressions) section.
</Steps>

## 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

<Steps>
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](/studio-v8/datasources/calculated-columns-datasource/) section.
</Steps>