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.
Be the first to comment