Forum Discussion
Inner Join
Hi
What is the DAX command for this scenario?
Let's say I have a large dataset where the two tables are merged via left join. Then I plotted a network diagram based on one variable A from left table against another variable B from the right table (not to be confused the variables are taken from the large merged dataset). Then I have a filter funnel on another variable. The result was a condensed network diagram with some common links between variable A and B. How to sieve out what are those items in variable A and B are common? Thanks
What is the DAX command for this scenario?
Let's say I have a large dataset where the two tables are merged via left join. Then I plotted a network diagram based on one variable A from left table against another variable B from the right table (not to be confused the variables are taken from the large merged dataset). Then I have a filter funnel on another variable. The result was a condensed network diagram with some common links between variable A and B. How to sieve out what are those items in variable A and B are common? Thanks
1 Reply
Sounds like a job for INTERSECT()
INTERSECT
Intersection of two tables, retaining duplicates.
Syntax
DAXCopyINTERSECT(<table_expression1>, <table_expression2>)Parameters
Term DefinitionTable_expression Any DAX expression that returns a table. Return value
A table that contains all the rows in table_expression1 that are also in table_expression2
