Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
I can think of two separate approaches to this.
I can think of two separate approaches to this.
Thanks for your reply, it worked!
can you please provide some data or dummy data?
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |