March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
10-07-2021 17:43 PM
UPDATE Feb 2022: Have updated the data source to Beijing 2022 results from https://www.eurosport.com/olympics/medals/ as the Olympics.com source is timing out.
We use historic Olympic medal data in our Power BI Essentials Skills course, so I have been waiting anxiously for the Tokyo 2020 Olympics to arrive. I've spruced up the file we use in the course by adding a link to the live Olympics.com Tokyo 2020 results and updating them every 30 minutes. I'll be blogging about how I created this report, the refresh, data alerts and automated Tweets throughout the Olympic Games, so subscribe to learn more: https://excelwithallison.blogspot.com/
eyJrIjoiMGQyNDBjOTctYTQxZC00ZTFiLTlkZjItZDA2MzgyY2JmZWYwIiwidCI6IjBiOGU2NWNiLWRjMmUtNDQ0Yy1hOGUwLTE4MmYyYTdmODc1YyJ9
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Awesome, great work indeed! I am a fan now 🙂
Nice work 🙂
Hi, May i have the dataset so that i can also try to build the same report as a practice.
@Anil2264 The dataset is all from the internet. Here's the first blog in the series for how I got the historical data: https://excelwithallison.blogspot.com/2021/07/tokyo-olympics-power-query-custom.html
Not sure if the links have changed since then (now that Olympics aren't live anymore) so it may need some small modifications....
Let me know how you get on! 🙂
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Very good report! At the bottom the pages are shown as "1 of 6" and it is also possible to see it with full screen. How did you do it? All the best,
@IF You can find the how to tutorials for most of the report on my blog: https://excelwithallison.blogspot.com/search/label/Tokyo%202020%20Olympics
The page navigation is just the built in navigation from Power BI when using share to web/embed in site, but I do have another blog on creating custom page navigations: https://excelwithallison.blogspot.com/2021/09/welcome-to-level-3-lockdown-with.html
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com