Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone!
I'm working with sports data and would like to know if there is any way to find a string inside a column (also a string) filtered for a third column. For example, the one below:
- To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played (every game has a different value in Full_Game column).
Secondly, I would like to know if, filtering for the MAX of Índice column + a Full_Game (to do the search in a game), it's possible to do the same exercise [To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played.]. The goal here is to know if a player started the game. If the string (Player) is in FiveOnCourt field, there would be yes and a starting five player, otherwise, the Player would not be in Starting Five.
Add you the pbix file and raw data: https://drive.google.com/drive/folders/1BxVWCtoHkcQYnDfOpqmYFpFgXpoEIPOt
Thank you for your time.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |