Skip to main content
Skip table of contents

Using Project Variables in Node Formulas

In the node formula editor, type $ to open the variable picker and select from the list of available variables.

As Dynamic Level Values

Variables are commonly used as level values in dimension parameters, especially for the time dimension. Instead of hardcoding a specific year, you can reference a variable that updates automatically.

Example: FILTER('Revenue', "Year", "$FC_End")

This pattern works in any function that accepts level values, such as FILTER that reference dimension members.

In DATA Function Parameters

Variables can be embedded anywhere within a DATA parameter string to dynamically reference data sources or tables:

DATA("Datasource_$Variable", "TableName", "MeasureName")

DATA("DataSourceName", "$TableName", "MeasureName")

This allows scenarios to switch between different data sources or tables without changing the formula. See the DATA function page for a full overview of placement patterns.

Related documentation

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.