INTERSECT
INTERSECT(set, set)
Keeps only the rows that are in both sets, such as the tasks upstream of this one that are also in its phase. Both sets must hold the same kind of row, and the result keeps schedule order.
Arguments
| Argument | What to give it |
|---|---|
| set | A set of rows: Upstream, FILTER(…), SAME([Phase]). |
| set | A second set of the same kind of row. |
Examples
Formula=COUNT(INTERSECT(Upstream, SAME([Phase])))
How many tasks of this task's own phase lie upstream of it.
Formula=ISEMPTY(INTERSECT(DrivingUpstream, SAME([WBS])))
TRUE when nothing in the task's own WBS node drives it: everything that sets its dates comes from elsewhere.
Formula=COUNT(INTERSECT(Predecessors, DrivingUpstream))
How many of the task's direct predecessors lie on its driving chain.
Reach for something else when
| You want | Use |
|---|---|
| Rows of one set that meet a condition | FILTER: FILTER(Upstream, Upstream[Phase] = [Phase]) reads the same as the first example |
| Rows in either set | UNION |
| Rows in the first set but not the second | EXCEPT |
| Whether one task is in a set | INCLUDES |
Common questions
Why does the editor say "INTERSECT needs two sets of the same kind"?
One set holds tasks and the other something else, such as links or assignments. InLinks is a set of links; Predecessors is the same tasks as a set of tasks.
=COUNT(INTERSECT(Upstream, InLinks))