Create overarching filter

[MaxSchrijen23]

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 project and a column team 2 that contains the second team which is attached to the project. These teams are attached via the persons working on the project, so it can be the case that the teamname in columns "Team1" and "Team2" are the same if the two persons in the project are part of the same team. 

Can I then in some way create a filter, or add a column which allows me to filter on columns "Team1" and "Team2" at the same time? Such that I can check if there are project which have the same team attached twice.

Kind regards!

[AlexisOlson · Accepted solution]

I can think of two separate approaches to this.

1. Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.
2. If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.

[MaxSchrijen23]

Thanks for your reply, it worked!

[vanessafvg]

can you please provide some data or dummy data?