Forum Discussion
Stack overflow error when deleting structured column without expanding it first
- 5 years ago
There are several oddities with deleting a column created from a nested join. It also breaks folding.
Rather than an anti-join, consider using a simple filter that uses List.Contains() - or in your case - not List.Contains(). This article will walk you through the equivalent of an inner join without creating unnecessary columns. By putting "not" in front of List.Contains, it will become an anti-join.
Using List.Contains To Filter Dimension Tables — ehansalytics
There are several oddities with deleting a column created from a nested join. It also breaks folding.
Rather than an anti-join, consider using a simple filter that uses List.Contains() - or in your case - not List.Contains(). This article will walk you through the equivalent of an inner join without creating unnecessary columns. By putting "not" in front of List.Contains, it will become an anti-join.
Using List.Contains To Filter Dimension Tables — ehansalytics