How to Create Week ID's in Power BI

📅 How to Create Week ID's in Power BI

Tracking data by week is a fundamental step in sports performance analysis, helping you organise and compare information consistently over time. Creating Week ID's in Power BI is a powerful way to keep your datasets structured and ready for meaningful insights.

In this hands-on tutorial from Jay Binning at Sport Horizon UK, you’ll learn how to build Week ID's using Power Query Editor, a key skill for anyone managing time-based data such as training loads, match schedules, or recovery periods.

Whether you’re analysing weekly trends or preparing data for reporting, this method ensures your information is clear, well-formatted, and easy to work with.

🔥 Ideal for sport scientists, analysts, and data professionals using Power BI in the world of sport.

What you’ll learn in this video as a practitioner:
1️⃣ How to change the formatting of columns to suit your data needs
2️⃣ How to create new column calculations for customised data fields
3️⃣ How to convert numbers into text format within your calculations

This practical guide will boost your Power BI skills and improve how you manage and analyse week-based data across multiple sources.

⸻

🎥 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]

⸻

#PowerBI #DataVisualisation #SportsAnalytics #SportScience #PerformanceAnalysis #PowerBI #DataAnalytics #Football #Soccer #SportHorizon #Excel #AthleteMonitoring #LoadMonitoring