SUBSTITUTEWITHINDEX DAX Function (Table manipulation)
Returns a table which represents the semijoin of two tables supplied and for which the common set of columns are replaced by a 0-based index column. The index is based on the rows of the second table sorted by specified order expressions.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
|
Table Iterator |
Table to be modified. |
|
| Name |
A name of the column to be added to the first table. |
|
| SemiJoinIndexTable |
Table that will be ordered and used to calculate index and to join with the first argument. |
|
|
Expression Row Context |
Repeatable |
Order by expression for the second parameter (SemiJoinIndexTable). |
| Order | Optional Repeatable |
The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending. |
Return values
A table which includes only those values present in the indexColumnsTable table and which has an index column instead of all columns present (by name) in the indexColumnsTable table.
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/substitutewithindex-function-dax