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.
Hope this article/video was helpful to you? Please leave your comments, suggestions or questions in the comments.
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s Saudi Arabia as the Head of ERP and Business Intelligence. He is interested in everything data-related, he likes to share his passion and knowledge with the data community.