TABLE DAX Statement
The TABLE keyword introduces a table definition (DEFINE) in a query (also known as query table).
The syntax after TABLE defines a query table, 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 table in a DAX query.
DEFINE TABLE Colors = DISTINCT ( 'Product'[Color] ) EVALUATE ADDCOLUMNS ( Colors, "Sales Amount", CALCULATE ( [Sales Amount], TREATAS ( { Colors[Color] }, 'Product'[Color] ) ) )
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