COLUMN DAX Statement
The COLUMN keyword introduces a table column (DEFINE) in a query (also known as query column).
The syntax after COLUMN defines a query column, which has a data lineage and it is populated in an empty filter context before the query is executed.
The following example shows using a query column in a DAX query.
DEFINE COLUMN Customer[First Letter] = LEFT ( Customer[Name], 1 ) EVALUATE SUMMARIZECOLUMNS ( Customer[First Letter], "Sales Amount", [Sales Amount] ) ORDER BY Customer[First Letter]
Last update: Aug 7, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/define-statement-dax