How to Extract Values from Columns in Power BI

🎯 How to Extract Values from Columns in Power BI

Want to quickly break down messy or multi-part ID columns in Power BI? In this tutorial, Jay Binning from Sport Horizon UK shows you how to use Power Query’s “Column from Examples” feature to extract specific values from composite fields.

Using a practical example, you’ll learn how to pull out key components like team names, home/away indicators, or score lines, all without needing complex formulas.

This skill is especially useful for sport scientists and performance analysts working with performance data where columns often hold multiple values. By separating out elements like player ID, session ID, or match context, you can make your datasets cleaner and more actionable.

📊 A must-watch for anyone who wants to streamline their data prep and build more powerful reports in Power BI.

✅ Quick, flexible, and great for cleaning up your raw data.

⸻

🎥 WATCH NEXT
🔹 📺 How to Move Data Labels in Tableau for Clearer Visuals
🔹 📺 Creating a Clean Power BI Dashboard from Raw Football Data
🔹 📺 How to Use Conditional Formatting in Power BI

⸻

Want to understand athlete monitoring and training load fundamentals, alongside learning how to build out bespoke training load and response dashboards and reports in Power BI?

Our new course with Jo Clubb from Global Performance Insights, Fundamentals of Load Monitoring, has gone live!

👉 Visit our landing page below to get access:

https://www.sporthorizon.co.uk/fundam...

🔗 And to learn more about the course and its applied benefits, check out this great introduction video featuring Ciaran Deely from Sport Horizon and Jo Clubb from Global Performance Insights.

They explore load monitoring, applied practice frameworks, and why learning Power BI is so valuable for practitioners:

👉    • Load Monitoring 101: Build Game-Changing D...  

⸻

🔔 SUBSCRIBE

Join our community and never miss a video – subscribe here:

👉 https://www.youtube.com/@SportHorizon...

⸻

☕ SUPPORT US

Found our content useful? You can now support our work:

👉 https://buymeacoffee.com/sporthorizon

⸻

👨‍🏫 ABOUT

At Sport Horizon, we support analysts, sport scientists, and coaches with tailored education in sports data analysis. Our team combines real-world experience in elite sport with expertise in tools like Power BI, Tableau, and Excel. Whether you’re working in football, GAA, rugby, or another team sport, we help you bridge the gap between data and performance.

⸻

🔗 CONNECT
• Website: https://www.sporthorizon.co.uk
• LinkedIn:   / sport-horizon-uk  
• X: https://x.com/SportHorizonUK
• 📧 For business inquiries: [email protected]