---
title: FIRSTNONBLANKX
description: Learn how to use the FIRSTNONBLANKX function to extract the first non-blank value based on specific conditions within calculated columns and data visualization widgets.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# FIRSTNONBLANKX

The FIRSTNONBLANKX function in Infoveave identifies the first 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 meeting the specified condition.

## Remark

FIRSTNONBLANKX extracts the initial non-empty data point while considering a condition, useful for responsive monitoring and alerting.  It provides selective and context-aware results.

## Syntax

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

## FIRSTNONBLANKX in Board Expression


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

**Parameters**

| Parameter       | Description                                                                                    |
|-----------------|------------------------------------------------------------------------------------------------|
| Expression      | A placeholder replaced with the actual widget and measure names.                               |
| Condition       | A placeholder replaced with the condition filter.                                              |
| Widget Name     | The specific name 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 | Specific dimension items within the dimension column used for widget visualization.           |

Steps to use FIRSTNONBLANKX in Board Expression

<Steps>
1. Write the FIRSTNONBLANKX function. For example ```FIRSTNONBLANKX(<expression>,<condition>)```
2. Where `expression` equals `'Widget Name'[Measure]` and `condition` equals `[Dimension Name]="Dimension Value"`.Replace **Widget Name**, **Measure**, **Dimension Name**, and **Dimension Value** with your actual values.
3. To learn how to configure an Expression in Infoveave, visit [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions).
</Steps>


## FIRSTNONBLANKX in Calculated Columns


| Parameter        | Description                                                                               |
|-------------------|-------------------------------------------------------------------------------------------|
| Expression       | A placeholder replaced with the column names.                                            |
| Condition        | A placeholder replaced with the condition filter.                                         |
| Column Name      | The name of the column containing the values you want to analyze.                         |
| Filter Condition | A filter condition (string or numeric) that returns data points meeting the defined condition. |

Steps to use FIRSTNONBLANKX in Calculated Columns

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

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