ROW DAX Function in Power BI

The ROW DAX function in Power BI is used to create a single-row table with one or more named columns containing values that result from the expressions given to each column. It’s especially useful when we want to construct small inline tables (for measures, debugging, or temporary calculations).

DAX Syntax ROW(name1, expression1[[,name2, expression2]…])

The function has the following parameters:

name: The name given to the column, enclosed in double quotes.
expression: Any DAX expression that returns a single scalar value to populate name.

Example: Create a single row.

DAX

MyRow =
ROW (
    "Country", "India",
    "Year", 2025,
    "Sales", 5000
)

Let’s click on the “New table” and paste the above code in that. We can visualize it by using the table visualization.

Example: Combine with UNION function.

DAX

MyTable =
UNION (
    ROW ("Product", "Laptop", "Price", 60000),
    ROW ("Product", "Mobile", "Price", 30000)
)

We can visualize it by using the table visualization.

Example: Use inside a measure.

DAX

MeasureTable =
ROW (
    "Current Date", TODAY (),
    "Total GDP", SUM ( Countries[GDP (Billion USD)] )
)

This can be used for debugging to quickly see values in a table format.

Previous Next