Forum Discussion
Solved
Create overarching filter
I want to create a that filters on two columns, containing the same data, at the same time. The table I have contains three columns, a projectName, a column containing team 1 that is attached to the...
I can think of two separate approaches to this.
- Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.
- If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.
I can think of two separate approaches to this.
- Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.
- If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.
Thanks for your reply, it worked!
