ROW function.
Returns a table with a single row containing values that result from the expressions given to each column.
Syntax
ROW(<name>, <expression>[[,<name>, <expression>]…])
Parameters
Term Definition
name The name of the column, enclosed in double quotes.
expression Any DAX expression that returns a single scalar value to populate name.
Example 1:
This formula returns total number of points and number of countries.
Example 2
with ADDCOLUMNS
ADDCOLUMNS(<table>, <name>, <expression>)
Row =
ADDCOLUMNS (
ROW (
"Points total", SUM ( tblTable[Points] ),
"Number of countries", DISTINCTCOUNT ( tblTable[Country] )
),
"Ratio", DIVIDE ( [Number of countries], [points total] )
)
Example 3
with UNION
syntax
UNION(<table_expression1>, <table_expression2> [,<table_expression>]…)
SELECTCOLUMNS
This function returns the selected columns from some source table.
Syntax:
SELECTCOLUMNS(<table>, <name>, <scalar_expression>)
Table manipulation functions are not supported for use in DirectQuery mode.
This function doesn't keep the source table columns
SelectColumns Vs. AddColumns
One big difference of SelectColumns and AddColumns is that AddColumns keep all the existing columns in the table and adds more columns to that, But the SelectColumns starts with no columns from the table, and builds a custom subset of columns or with additional calculated columns on it.
Comments