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
In this video, I share my solution to a Power query challenge posted on the Excel BI Linkedin page on 17 Oct 2022. It may seem that the question is simple, but there are some nuances that must be taken into account in order to come up with a robust solution. By combining a variety of versatile List, Table, Text, and more functions in Power Query, I will demonstrate how to achieve a flexible solution by utilizing the power of the “M” language.
Download the PBIX file here: https://excelfort.com/power-query-challenge-solution-no-of-wins-by-soccer-teams/
Hope this article/video was helpful to you? Please leave your comments, suggestions or questions in the comments.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.