In this blog post, we provide a step-by-step guide on how to use the Group By function in Power Query to reduce the number of rows in your data tables. Whether you are working in Power BI or Excel, this post will show you how to aggregate your data by a grouping variable to build a leaner and faster data model.
In this blog post, we explain the difference between Duplicate and Reference in Power Query - both in Power BI and Excel.
In this blog post, we explore different techniques of splitting the values from a column in Power Query into multiple columns. This data transformation step is applicable in Microsoft Power BI and Excel.
In this blog post, we provide M code to replace the values in a column in Power Query that don’t match a list of strings provided. The M code allows you to do this in one simple and efficient step. This data transformation can be performed in Power BI or Excel.
In this blog post, we explain what is involved in merging queries in Power Query - in Power BI or Excel - and provide a step-by-step guide.