-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
DAX includes several interesting functions that have multiple tables as parameters. To investigate these functions, create the following calculated tables, referring to Figure 2.15 for the steps if necessary.
Union Table = UNION( 'Table', 'Table' )
The DAX UNION function appends two tables together. Each table must have the same number of columns.
The DAX EXCEPT function returns all of the rows from the first table parameter that do not appear in the second table parameter. For example, the following formula returns only the rows in the table Table where the Item column does not have a value of “Banana”.
Except Table =VAR __Table = FILTER( 'Table', [Item] = "Banana" )VAR __Result = EXCEPT( 'Table', __Table )RETURN__Result
The INTERSECT function is the exact opposite of the EXCEPT function and thus the following DAX formula only returns rows where the...